SQL Server Performance Forum – Threads Archive
Temporary Authorization
Is there a way to make a role assignment temporary? Giving access to a folder on the server that expires, say, at the end of the day. Joe Jankain my opinion you can schedule the job that can create a user assign and add user to proper role/group and then after processes completed it will delete / remove / disable user.
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami
If the permission needs to be set on operating system folder then you must check under Win2K newsgroups for such snippets, in SQL you can refer to Books online for granting permission on database level. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ghemant</i><br /><br />in my opinion you can schedule the job that can create a user assign and add user to proper role/group and then after processes completed it will delete / remove / disable user.<br /><br /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />if you wants to set this for windows os then only one thing you should change is the login time / day for said user from accout option under control panel – administrative tools – users and group or in active directory in case of domain controller<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
]]>