Access Privileges

Initially, only a table’s creator, its owner, and the SYSDBA user have access to a table. On UNIX servers that have a superuser, or a user with root privileges, those users also have access to all database objects.

You can grant other users the right to look at or change your tables by assigning access privileges using the GRANT statement. Table 1 lists the available access privileges:

Table 1: SQL Access Privileges

Privilege	Access
ALL	SELECT, DELETE, INSERT, UPDATE, and REFERENCES; note that ALL does not include the EXECUTE privilege
SELECT	Read data
DELETE	Delete Data
INSERT	Write new data
UPDATE	Modify existing data
EXECUTE	Execute or call a stored procedure
REFERENCES	Reference a primary key with a foreign key
ROLE	All privileges assigned to the role

The GRANT statement assigns access privileges for a table or view to specified users, roles, or procedures. The REVOKE statement removes previously granted access privileges.

Advance To:

Assigning Privileges with GRANT