Use the create role command to create a role. The syntax is:
create role role_name [with passwd "password"]
where:
role_name – is the name of a new role.
password – is an optional password that must be specified by the user who will use the role.
For example, to create the intern_role without a password, enter:
create role intern_role
To create the doctor_role and assign the password “physician”, enter:
create role doctor_role with passwd "physician"
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
