Skip to Main Content

Database Software

Grant acess with an expiry date

blkrishnaraoJan 30 2016

We genuinely keep getting request where an escalated issue or production issue comes in as high priority and the technical person is not sure of the number of objects he needs access to and keeps coming back again and again to ask multiple grants.

The difficult part turns out to revoke those grants once the issue is resolved.

So here in cases like this if we have an command with expiry that would revoke the access automatically after that many days.

Grant select any table to user1 expire 1 day;

Post Details
Added on Jan 30 2016