August 4, 2016 at 9:24 am
Hi,
I'm googling but i can't find any answer for my question.
Is it possible to create a login (or permissions for a login) with an expiration date and time? for example someone comes to me asking for read only access to certain table and i want to give him access that access but only for 2 days, then i have another user asking for access to a different table for a week.
I know certificates have expiration day on them and they can be used to sign procedures etc but is there a way i could use this or similar functionality to solve my problem? Or do i have to create my own solution to manage that?
August 4, 2016 at 9:54 am
Why don't you just create a job that'll drop them on the dates you specify?
August 4, 2016 at 9:59 am
First i want to find out if there is a known functionality in sql server that can handle it, if not then i will create a solution to handle it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply