Privilege

The Privilege category is located in the Root > Script > Objects category, and can contain the following items that define how privileges are modeled for your DBMS.

Item

Description

[Common items]

The following common object items may be defined for privileges:

  • AfterCreate, AfterDrop, AfterModify

  • BeforeCreate, BeforeDrop, BeforeModify

  • Create, Drop

  • Enable

  • ModifiableAttributes

  • ReversedQueries, ReversedStatements

For a description of each of these common items, see Common object items.

GrantOption

Specifies the grant option for a privileges statement.

Example (Oracle 10g):

with admin option

RevokeInherited

Allows you to revoke inherited privileges from groups and roles.

RevokeOption

Specifies revoke option for a privileges statement.

System

Specifies a list of available system privileges.

Example (ASE 15):

CREATE DATABASE
CREATE DEFAULT
CREATE PROCEDURE
CREATE TRIGGER
CREATE RULE
CREATE TABLE
CREATE VIEW
Parent topic: Script/Objects Category