A role is a classification with privileges on database objects granted to the role. The DBA can assign the privileges of a related work task, such as an engineer, to a role and then grant that role to users, instead of granting the same set of privileges to every user. After a role is created, the DBA can use the GRANT statement to grant the role to users or to other roles.
The following dbschema command and output show the privileges that were granted for the calen role:
sharky% dbschema -p calen -d stores_demo DBSCHEMA Schema Utility INFORMIX-SQL Version 7.22 Copyright (C) IBM Corporation, 1984-1996 Software Serial Number RDS#N000000 grant alter on table1 to 'calen'Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]