Forum Stats

  • 3,874,686 Users
  • 2,266,766 Discussions


Grant acess with an expiry date

blkrishnarao Member Posts: 24
edited Jan 30, 2016 3:58PM in Database Ideas - Ideas

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;

William RobertsonBPeaslandDBAKayKChizzle PackctriebSven W.
6 votes

Active · Last Updated