- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Grant acess with an expiry date
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;