Role Creation

Home | Previous Page | Next Page Data Migration Utilities > The dbschema Utility >

Role Creation

Roles:
 
|--+---------------+--------------------------------------------|
   '- -r--+-role-+-'
          '-all--'

Element	Purpose	Key Considerations
-r role	Displays the CREATE ROLE and GRANT statements that are needed to replicate and grant the specified role.	Restriction: You cannot specify a list of users or roles with the -r option. You can specify either one role or all roles. SE does not support the -r option.
-r all	Displays all CREATE ROLE and GRANT statements that are needed to replicate and grant all roles.	None

The following dbschema command and output show that the role calen was created and was granted to cathl, judith, and sallyc:

sharky% dbschema -r calen -d stores_demo

DBSCHEMA Schema Utility       INFORMIX-SQL Version 7.22 
Copyright (C) IBM Corporation, 1984-1996 
Software Serial Number RDS#N000000 
create role calen; 

grant calen to cathl with grant option; 
grant calen to judith ; 
grant calen to sallyc ;