Group Management

Once you understand how to manage permissions for individual users (as described in the previous section) working with groups is straightforward.

• Creating Groups in Interactive SQL
  A group is identified by a user ID, just like a single user, but this user ID is granted the permission to have members.
• Creating Groups in Sybase Central
  You can use Sybase Central to create groups.
• Creating Groups in Sybase Control Center
  For instructions on creating a Sybase IQ group in Sybase Control Center, see the Sybase Control Center for Sybase IQ online help in SCC or at http://sybooks.sybase.com/nav/summary.do?prod=10680.
• Adding Group Members in Interactive SQL
  The GRANT statement makes a user a member of a group.
• Adding Group Members in Sybase Central
  When users are assigned membership in a group, they inherit all the permissions on tables, views, and procedures associated with that group.
• Adding Group Members in Sybase Control Center
  For instructions on adding members to a Sybase IQ group in Sybase Control Center, see the Sybase Control Center for Sybase IQ online help in SCC or at http://sybooks.sybase.com/nav/summary.do?prod=10680.
• Permissions of Groups
  Permissions may be granted to groups in exactly the same way as to any other user ID.
• Tables Owned by Groups
  Groups are used for finding tables and procedures in the database.
• Groups Without Passwords
  Users connected to a group's user ID have certain permissions. Such users would also have ownership permissions over any tables in the database created in the name of the group's user ID.
• Groups Created Automatically
  When a database is created, two groups are also automatically created. These are SYS and PUBLIC. Neither of these groups has passwords, so it is not possible to connect to the database as either SYS or as PUBLIC. The two groups serve important functions in the database.