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 |
|
ketu0001
Starting Member
11 Posts |
 Posted - 2007-06-11 : 07:02:15
|
| HiMy doubts on revoked users in MSSQL...please replyI have following doubts:1. Is there any stored procedure provided by MS SQL server for checking whether the user is revoked or not?2. What is the query for checking whether the particular user is revoked or not in MS SQL?3. Do all revoked users get stored in separate database in MSSQL ?Please reply. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-11 : 09:10:50
|
| 3. No - it is a status of the user in the database. (You revoke permissions from a user).For the rest have a look at sys.server_permissions and the security functions/tables.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-11 : 17:51:42
|
| You can either revoke permission from user or drop user, which one you need to do? |
|
|
|
|
|
|
My doubts on revoked users in MSSQL...please reply