Restricting the TAU (Trifling Ass User)

This one is elementary but I’m posting for reference purposes.

If you have a user that needs permission to tables and not the entire database…or if you dont want them to see anything other than what they need to, you will need to set table level permissions.

For a specific username and table use:
GRANT SELECT, UPDATE, etc… ON tableName TO “username”

Cheers

Leave a Reply

Your email address will not be published. Required fields are marked *