need to assign temporary DBA role
848473Jun 14 2012 — edited Jun 14 2012Hi All,
I have once user name u1 it has access to select any table on database. now i want to assign u1 role as DBA but it should for some set of time like 20 min and it should be revoke after that.
how i can assign DBA role to u1 for 20 min?