7-34 IBM Informix OnLine Database Server Administrator’s Guide
Include Privileges
Include Privileges
If you specify all for user, dbschema outputs GRANT statements for all users
for the database, table, or view specified.
In the dbschema output, the AS keyword indicates the grantor of a GRANT
statement. The following example output indicates that norma issued the
GRANT statement:
GRANT ALL ON "tom".customer TO "claire" AS "norma"
When the GRANT and AS keywords appear in the dbschema output, you
might need to grant privileges before you run the dbschema output as an
SQL script. Referring to the previous example output line, the following
conditions must be true before you can run the statement as part of a script:
■ norma must have Connect privilege to the database.
■ norma must have all privileges WITH GRANT OPTION for the table
tom.customer.
For more information about the GRANT statement, refer to IBM Informix Guide
to SQL: Reference.
-p user directs dbschema to output the GRANT statements that grant
privileges to user.
Privileges
-p user
