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 |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2010-03-29 : 15:44:52
|
| I have inherited a SQL 2000 db from a previous DBA. I get this error when I execute this line of code:GRANT SELECT ON master.dbo.sysxlogins TO AppUserCannot find the object 'sysxlogins', because it does not exist or you do not have permission.Why would the previous DBA have this line of code, if the object does not exist or sysadmin access has no permission? |
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-04-01 : 05:50:49
|
| Hi ,First your login should have access to syslogins. then only you can grant permission on that.your query should work if your are in sa login or some other login with admin permission.Regards,Sathieshkumar. R |
 |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-04-01 : 09:35:17
|
| I realized that I was trying to execute on SQL Server 2005. It works on SQL Server 2000. |
|
|
|
|
|
|
sysxlogins error