Each Adaptive Server user must have a login account that is established by a system security officer. Login accounts have:
A login name, unique on that server.
A password. Sybase recommends that you periodically change your password. See Chapter 14, “Managing Adaptive Server Logins, Database Users, and Client Connections,” in the System Administration Guide Volume 1.
(Optional) A default database . If a default is defined, the user starts each Adaptive Server session in the defined database without having to issue the use command. If no default is defined, each session starts in the master database.
(Optional) A default language. This specifies the language in which prompts and messages display. If a language is not defined, Adaptive Server’s default language, which is set at installation, is used.
(Optional) A full name. This is your full name, which can be useful for documentation and identification purposes.
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.
