Clever Geek Handbook

Hiding / locking tables in oracle

How can I hide / lock multiple tables in Oracle so that only my application has access to modify that data in the table?

+1


source to share


3 answers


Create a user / login to a database that you can control. Assign the user as the owner (using grants) of the tables you need to "hide / lock". Use grants to make tables inaccessible (or read-only) to other users.



+1


source


All you have to do is create a new user and create tables under this custom schema. None of the other users other than high-priority users with SELECT / INSERT / etc ALL TABLES privileges will be able to access them unless you grant them the privilege or role that has been granted to them.



If you want the ultimate security model that probably doesn't exist, create a table under one schema (for example APP_DATA) and create a stored procedure under another (APP_CODE). Grant only the required privileges on APP_DATA objects for the APP_CODE schema, and grant only the required privileges in the APP_CODE schema for other users.

+1


source


After creating a user, make sure you remove grants for other users. By default, users have a grant by default. So make sure your user has all the grants.

0


source






More articles:


All Articles