Access privileges to complete schema
731838Dec 9 2009 — edited Dec 10 2009I am using 10.2.0.4 database.
I want to create a user account who has read permissions on a couple of schemas in the database.
I am not sure whether there is an easy way of doing it as I normally do it by creating a script containing all the obejcts and with another script which grants the relevant privileges to the appropriate accounts.
So my client was asking that if he adds some objects later to the source schema will the user accounts dynamically have privileges to those objects for which I said that manual intervention is required.
Correct me if I am wrong. Let me know whether there is any other easy way of doing this dynamically?