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 |
|
satishk
Starting Member
39 Posts |
 Posted - 2007-01-16 : 02:21:09
|
| Hi All Gentleman,I am writing a script to control rights and privileges regarding roles and login .I have upgraded my server from sql server 2000 to 2005.I have a script which gives me all the logins that moved from sql server 2000 to sql server 2005 (i.e same instance)or on same server.I have multiple database say for example 5 database.Now my task is to grant all programmers login to programmer role and all logins belonging to this role should be granted only select permission on table on all the databases.Can anyone help me with the script for my task?I have observed that sysxlogins table exist in sql server 2000 however it does not exist in sql server 2005.Can anyone tell me what is the equivalent of sysxlogins system table in sqlserver 2005? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-16 : 02:28:04
|
| There is no sysxlogins table in SQL 2005. In SQL 2000 also, it was undocumented. You can try using either of the following catalog views:1. Sys.Server_Principals2. Sys.sql_loginsHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
satishk
Starting Member
39 Posts |
Posted - 2007-01-16 : 02:42:51
|
| Harsh plz provide with list of all the sql server 2005 system tables and information schema viewSatish India |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-16 : 02:49:05
|
| For system tables see this:[url]http://msdn2.microsoft.com/en-us/library/ms179932.aspx[/url][url]http://msdn2.microsoft.com/en-us/library/ms179503.aspx[/url]For catalog views in SQL 2005 see this:[url]http://msdn2.microsoft.com/en-us/library/ms187997.aspx[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
what is the quivalent of sysxlogins table in sql s