Tables System Privileges
System privileges pertaining to performing authorized tasks on tables.
ALTER ANY TABLE System Privilege
Required to alter any table owned by anyone.
CREATE ANY TABLE System Privilege
Required to create tables owned by any user.
CREATE PROXY TABLE System Privilege
Required to create self owned proxy tables.
CREATE TABLE System Privilege
Required to create self owned tables.
DELETE ANY TABLE System Privilege
Required to delete rows from tables, table partitions, or views owned by any user.
DROP ANY TABLE System Privilege
Required to drop tables owned by any user.
INSERT ANY TABLE System Privilege
Required to insert rows into tables and views owned by anyone.
LOAD ANY TABLE System Privilege
Required to execute LOAD command for any table where the -gl server switch is set to DBA.
SELECT ANY TABLE System Privilege
Required to query tables, views, or materialized views owned by any user.
TRUNCATE ANY TABLE System Privilege
Required to execute TRUNCATE command for any table.
UPDATE ANY TABLE System Privilege
Required to update rows in tables and views owned by any user.
Parent topic:
System Privileges Listed by Functional Area
Related reference
List All System Privileges
Created May 21, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com