Скачать или смотреть Sybase ASE - How to Create Database Roles and Groups in SAP Sybase ASE

Lab 7 : Creating and Using Roles
Objective : Create Role and Manage Login Policies
1. Creates a role named doctor_role:
create role doctor_role
2. Creates a role named doctor_role with the password “physician”:
create role doctor_role with passwd "physician"
3. Sets passwd expiration to 7 days. The password for the role expires at the time of day that the password was last changed after the specified period has passed:
create role intern_role with passwd "temp244",
passwd expiration 7
4. Sets the maximum number of failed logins allowed for intern_role:
create role intern_role with passwd "temp244"
max failed_logins 20
5. Sets the minimum password length for intern_role:
create role intern_role with passwd "temp244",
min passwd length 0

Visit www.theskillpedia.com for Online Training on this technology
SAP Sybase ASE - How to Create Database Roles and Groups in SAP Sybase ASE
sybase,sybase tutorials,how to create database roles and groups in sap sybase ase,roles,login system in c#,create login in sybase server,sybase login create examples,sybase login create,sybase login policy,sybase iq,sybase server start and stop,sybase tutorial for beginners,how to create login in sybase server,how to create user login in sap sybase,roles and groups,sybase database backup and restore step by step,assign roles and privilege