Attempting to use AD_ZD.GRANT_PRIVS to add a role to a user account.
What I am attempting to do is...
1. Create a role
2. Assign select on table# to the role
3. Assign the role to a user
How can I accomplish this without causing real-time recompiles in the database?
0