IBM 000-8697 Manual de usuario descargar pdf (Pagina 512)

100

101

7-34 IBM Informix OnLine Database Server Administrator’s Guide

Include Privileges

Ifyouspecifyall foruser, dbschema outputsGRANT statementsforallusers

for the database, table, or view speciﬁed.

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.

FormoreinformationabouttheGRANTstatement,refertoIBM InformixGuide

to SQL: Reference.

-p user directs dbschema to output the GRANT statements that grant

privileges to user.

Privileges

-p user

1 2 ... 507 508 509 510 511 512 513 514 515 516 517 ... 701 702

Comentarios a estos manuales

Sin comentarios

IBM 000-8697 Manual de usuario Pagina 512

Comentarios a estos manuales

Relacionado con productos y manuales para Software de base de IBM 000-8697