IBM 000-8697 Manual Do Utilizador
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 I
nformix
G
uide
to
SQL: R
eference.
-p user
directs dbschema to output
the GRANT
statements that grant
privileges to user.
Privileges
-p user