I got a peculiar request to restrict a user from specific actions on a table.
Condition:
Restrict a user from inserting/updatin/deleting the records in a specific table.
Solution:
We can use deny statement to achieve this task. Below is the query for the same,
DENY INSERT, UPDATE, DELETE
ON aa
TO venkat
Thanks and Regards,
Venkatesan Prabu .J
No comments:
Post a Comment