An Example of Setting Up Security

An Example of Setting Up Security

 

Name                  Role                  Operating System Login Name

Ralph Smith           sso_role               ralph

Kathy Masters         sa_role                kathy

Mary Randolph         sa_role                mary

Gene Wishing          oper_role              gene

 

 

1.isql -Usa

 

2.sp_audit "security","all","all","on"

  sp_audit "all","sa_role","all","on"

  sp_audit "all","sso_role","all","on"

 

3.sp_configure"auditing",1

 

4.sp_addlogin ralph,meijia,@fullname="Ralph Smith"

  sp_addlogin kathy,meijia,@fullname="Kathy Masters"

  sp_addlogin mary,meijia,@fullname="Mary Randolph"

  sp_addlogin gene,meijia,@fullname="Gene Wishing"

 

5.grant role sso_role to ralph

  grant role sa_role to mary

  grant role sa_role to kathy

  grant role oper_role to gene

 

6.use sybsecurity

  sp_changedbowner ralph

 

7.sp_locklogin sa,"lock"