GRANT statement
542
GROUP Allows the user(s) to have members.
$ For more information, see "Managing groups" on page 753 of the book
ASA User’s Guide.
MEMBERSHIP IN GROUP This allows the user(s) to inherit table
permissions from a group and to reference tables created by the group
without qualifying the table name.
$ For more information, see "Managing groups" on page 753 of the book
ASA User’s Guide.
Syntax 3 of the GRANT statement is used to grant permission on individual
tables or views. The table permissions can be specified individually, or you
can use ALL to grant all six permissions at once.
RESOURCE Allows the user to create tables and views. In syntax 2, ALL
is a synonym for RESOURCE that is compatible with Sybase Adaptive
Server Enterprise.
ALL In Syntax 3, this grants all of the permissions outlined below.
ALTER The users will be allowed to alter the named table with the
ALTER TABLE statement. This permission is not allowed for views.
DELETE The users will be allowed to delete rows from the named table or
view.
INSERT The users will be allowed to insert rows into the named table or
view.
REFERENCES [(column-name, …)] The users will be allowed to create
indexes on the named table, and foreign keys which reference the named
tables. If column names are specified, the users will be allowed to reference
only those columns. REFERENCES permissions on columns cannot be
granted for views, only for tables.
INDEX is a synonym for REFERENCES.
SELECT [(column-name, …)] The users will be allowed to look at
information in this view or table. If column names are specified, the users
will be allowed to look at only those columns. SELECT permissions on
columns cannot be granted for views, only for tables.
UPDATE [(column-name, …)] The users will be allowed to update rows
in this view or table. If column names are specified, the users will be allowed
to update only those columns. UPDATE permissions on columns cannot be
granted for views, only for tables.
To Next Page
Loading...