![]() These privileges must be granted directly to the owner rather than acquired through roles. If the trigger issues SQL statements or invokes procedures or functions, then the owner of the trigger must have the privileges necessary to perform these operations. For information about enabling editions for a user, see Oracle Database Development Guide. In addition to the preceding privileges, to create a crossedition trigger, you must be enabled for editions. ![]() ![]() For information about PDBs, see Oracle Database Administrator's Guide. To create a trigger on a pluggable database (PDB), you must be connected to that PDB and have the ADMINISTER DATABASE TRIGGER system privilege. In addition to the preceding privileges, to create a trigger on DATABASE, you must have the ADMINISTER DATABASE TRIGGER system privilege. SCHEMA), you must have the CREATE ANY TRIGGER system privilege. To create a trigger in any schema on a table in any schema, or on another user's schema ( schema. To create a trigger in your schema on a table in your schema or on your schema ( SCHEMA), you must have the CREATE TRIGGER system privilege.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |