Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-05-13 : 15:55:30
|
| Hi Gurus,Is there any to get time as when DBA's grated permissions on particular database...Please advice..This will be very helpfull to me..Thanks,ServerTeam |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-05-14 : 09:25:56
|
| Sorry if my post is not clear.I am posting again..I want to know the detials of my login.For example..I requested my DBA team as to grant Read only access to my login on particular DB which i don't have.I got reply as i already have access.Now i want to know when access granted to my login befor or after i requested to DBA team.I mean at what time my DBA group granted Read access to my login on particular database..Thanks,ServerTeam |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-14 : 09:35:43
|
| Can't you ask your DBA? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-14 : 10:11:50
|
| This information (date/time of grant) is not kept in SQL Server. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 22:47:04
|
| You can just run a simple select statement. If didn't work before but works after asking permission, you know what happens regardless whatever your dba said. |
|
|
|
|
|
|
User permissions time log