SQL Reference Guide > SQL Reference Guide > SQL Statements > GRANT (privilege) > Privilege Defaults
Was this helpful?
Privilege Defaults
Privilege defaults are as follows:
Privilege
Default
SELECT
INSERT
DELETE
UPDATE
Only the owner can perform select, insert, delete, or update operations on objects it owns.
REFERENCES
Only the table owner can create referential constraints that see its tables.
EXECUTE
Only the owner of a database procedure can execute the procedure.
RAISE
Only the owner of a database event can raise the event.
REGISTER
Only the owner of a database event can register to receive the event.
NEXT
Only the owner of a database sequence can execute the next value and current value operators on the sequence.
Database privilege defaults are as follows:
Privilege
Description
QUERY_IO_LIMIT
Any user can perform unlimited I/O (noquery_io_limit)
QUERY_ROW_LIMIT
Any user can obtain unlimited rows (noquery_row_limit).
CREATE_TABLE
Any user can create tables (create_table).
CREATE_PROCEDURE
Any user can create database procedures (create_procedure).
CREATE_SEQUENCE
Any user can create database sequences (create_sequence).
LOCKMODE
Any user can issue the set lockmode statement (lockmode).
DB_ADMIN
For a specified database, the DBA of the database and users that have the security privilege have the db_admin privilege. All other users of the database have nodb_admin privilege.
Last modified date: 04/26/2024