tozysentosa
asked on
ORACLE - Granting priviliege for user to read tables, run packages only
Hi,
How do I garnt privilege to a new user only to read from tables and only to run packages in Oracle?
How do I garnt privilege to a new user only to read from tables and only to run packages in Oracle?
Granting "select any table" will give the user freedom to select any tables data in existing schemas as well as for new additions in the whole database. I think the better policy would be u should give "minimum rights" as per function & role of the user in the system. So it would be the best practice to only give "select" grants those tables actually the user should supposed to access
For give grants on individual tabes & procedures
use
tables:
GRANT select on <other_schema>.<table_name > TO <your_user>;
Procedures:
GRANT execute on <other_schema>.<table_name > TO <your_user>;
For give grants on individual tabes & procedures
use
tables:
GRANT select on <other_schema>.<table_name
Procedures:
GRANT execute on <other_schema>.<table_name
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi thanks it works...
GRANT SELECT ANY TABLE TO your_user;
for the packages:
GRANT EXECUTE ANY PROCEDURE TO your_user
you might want to save this bookmark:
http://www.techonthenet.com/oracle/grant_revoke.php