Chapter 3 DBMS Resource File Reference

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

 

Copyright (C) 2008. Sybase Inc. All rights reserved.