The responsibility of adding new logins to Adaptive Server, adding users to databases, and granting them permission to use commands and database objects is divided among the System Security Officer, System Administrator, and Database Owner.
The “Adding new users” procedure creates login accounts
for a particular server using sp_addlogin,
which stores account information in the syslogins table
on that server. You can also create and store login accounts on a
LDAP server.
Adding new users
A System Security Officer uses sp_addlogin to create a server login account for a new user.
A System Administrator or Database Owner uses sp_adduser to add a user to a database. This command can also give the user an alias or assign the user to a group. For more information, see “Creating groups”.
A System Security officer grants specific roles to the user.
A System Administrator, Database Owner, or object owner grants the user or group specific permissions on specific commands and database objects. Users or groups can also be granted permission to grant specific permissions on objects to other users or groups. See Chapter 17, “Managing User Permissions” for detailed information about permissions.
Table 14-1 summarizes the system procedures and commands used for these tasks.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
