User access that expires after certain time, 60, 90 days, etc
Oracle 10.2.0.4 will be moving to 11.2.0.3 in few months.
RAC =Four nodes
OS = Linux 6.0
I need to implement the following 3 items:
we have sensetive data in our database
1. beside from creating a view, is there a way for me to give select /DML access to a user(s) who can see only few columns in a table and not a entire table?
2. is there a way for me to give select / DML access on a table or tables or a role to a user that expires after certain dates or 30,60 or 90 days from the grant date? I do not mean all grants for this user but only certain grants.
RAC =Four nodes
OS = Linux 6.0
I need to implement the following 3 items:
we have sensetive data in our database
1. beside from creating a view, is there a way for me to give select /DML access to a user(s) who can see only few columns in a table and not a entire table?
2. is there a way for me to give select / DML access on a table or tables or a role to a user that expires after certain dates or 30,60 or 90 days from the grant date? I do not mean all grants for this user but only certain grants.
0