IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

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:

■

 must have Connect privilege to the database.

■

 must have all privileges

WITH GRANT OPTION

 for the table

.

For more information about the

GRANT

statement, refer to

eference.

directs dbschema to output

the GRANT

 statements that grant

privileges to user.

Privileges

-p user