Adaptive Server login accounts

Each Adaptive Server user must have a login account that is established by a system security officer. Login accounts have:

Use sp_displaylogin to view information about your own Adaptive Server login account.

Use groups to grant and revoke permissions to more than one user at a time within a database. For example, if everyone who works in the Sales department needs access to certain tables, all of those users can be put into a group called “sales.” The database owner can grant specific access permissions to that group rather than granting permissions individually. See Chapter 14, “Managing Adaptive Server Logins, Database Users, and Client Connections,” in the System Administration Guide Volume 1

System security officers can use roles as a convenient way to grant and revoke server-wide permissions to several users simultaneously. For example, clerical staff may need to insert and select from tables in several databases, but they may not need to update them. A system security officer can define a role called “clerical_user_role” and grant the role to everyone in the clerical staff. Database object owners can then grant the required privileges to “clerical_user_role.” See Chapter 13, “Getting Started With Security Administration in Adaptive Server,” in the System Administration Guide Volume 1.

You can execute stored procedures on a remote Adaptive Server using remote procedure calls if you have been granted access to the remote server and an appropriate database on that server. See Chapter 15, “Managing Remote Servers,” in the System Administration Guide Volume 1.