![background image](http://html1.mh-extra.com/html/sybase/adaptive-server-iq-12-4-2/adaptive-server-iq-12-4-2_administration-and-performance-manual_1416503384.webp)
Managing groups
364
3
Give the personnel user ID the permission to have members, with the
following SQL statement:
GRANT GROUP TO personnel
The GROUP permission, which gives the user ID the ability to have members,
is not inherited by members of a group. If this were not the case, then every
user ID would automatically be a group as a consequence of membership in the
special PUBLIC group.
Creating groups in
Sybase Central
❖
To create a group in Sybase Central:
1
Connect to the database.
2
Click the Users and Groups folder for that database.
3
Double-click Add Group. A Wizard leads you through the process.
For more information, see the Sybase Central online Help.
Granting group membership to users
Making a user a member of a group is done with the GRANT statement.
Membership in a group can be granted either by the DBA or by the group user
ID. You can grant user
M_Haneef
membership in a group
personnel
as follows:
1
Connect to the database as a user with DBA authority, or as the group user
ID
personnel
.
2
Grant membership in the group to
M_Haneef
with the following SQL
statement:
GRANT MEMBERSHIP
IN GROUP personnel
TO M_Haneef
When users are assigned membership in a group, they inherit all the
permissions on tables, views, and procedures associated with that group.
Adding users to
groups in Sybase
Central
❖
To add a user to a group in Sybase Central:
1
Connect to the database.
Summary of Contents for Adaptive Server IQ 12.4.2
Page 1: ...Administration and Performance Guide Adaptive Server IQ 12 4 2 ...
Page 16: ...xvi ...
Page 20: ...Related documents xx ...
Page 40: ...Compatibility with earlier versions 20 ...
Page 118: ...Troubleshooting startup shutdown and connections 98 ...
Page 248: ...Importing data by replication 228 ...
Page 306: ...Integrity rules in the system tables 286 ...
Page 334: ...Cursors in transactions 314 ...
Page 396: ...Users and permissions in the system tables 376 ...
Page 438: ...Determining your data backup and recovery strategy 418 ...
Page 484: ...Network performance 464 ...
Page 500: ...System utilities to monitor CPU use 480 ...
Page 514: ...Characteristics of Open Client and jConnect connections 494 ...
Page 536: ...Index 516 ...