CODEWITHSUNDEEP
sqldb2
satya
satya

Reputation: 109

DB2 - Restrict a DB User to just use Select, Insert and Update Operations

i want to restrict a db2 user to just do some operations like select,insert and update operations. Is there a way in DB2 to do it? i am newbie to db2. Please let me know Thanks in advance

Upvotes: 0

Views: 77

Answers (1)

Lukas Eder
Lukas Eder

Reputation: 220887

This is what you use GRANT for. Examples from the manual:

GRANT SELECT ON DSN8A10.EMP TO SOME_USER;
GRANT UPDATE (EMPNO, WORKDEPT) ON TABLE DSN8A10.EMP TO SOME_USER;

In general, in SQL databases, you don't restrict privileges, you grant them, starting from almost no privileges.

Upvotes: 2

Related Questions