CODEWITHSUNDEEP
sql
jdczw
jdczw

Reputation: 199

Disable SELECT or INSERT or UPDATE or DELETE statement for specific/certain TABLE

I allowed user to input SQL statement in the system

But there are some data that i want to hide from user

Is there any way that i can disable INSERT or SELECT or UPDATE or DELETE statement on selected TABLE?

Upvotes: 1

Views: 737

Answers (1)

Locons
Locons

Reputation: 36

Use:

REVOKE privileges ON object FROM user;

For example:

REVOKE ALL ON employees FROM anderson;
REVOKE INSERT ON employees FROM anderson;

Upvotes: 2

Related Questions