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 |
santillo777
Starting Member
4 Posts |
Posted - 2008-06-04 : 14:23:34
|
Is there a reason why a record in sys.sysuser would be visible to the system admin login but not to a standard user? If I want the standard user to see all the records in sys.sysuser, is there a permission setting I can change to make that happen? If I give the standard user system admin permissions, all records show up. But I cannot keep the standard user as system admin. Thanks. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-04 : 14:44:50
|
Why would anyone want to look in sys.sysuser?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
santillo777
Starting Member
4 Posts |
Posted - 2008-06-04 : 15:04:36
|
We use Hyperion Intelligence for analysis against SQL Server. Hyperion uses a query that joins sysuser to sysobjects to get the table catalog used to visually build queries. Because of the hidden record in sysuser, the inner join results in an empty result set causig the table catalog in Hyperion to be empty. So it's pretty important to understand how to understand why there is a missing record in sysuser. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-04 : 15:11:05
|
I'm confused as you've posted your question in the 2000 forum, yet sys.sysusers is in 2005. sysusers is in 2000 though. So which version are you using? If 2005, why can't it sys.database_principals? Or does that not solve the problem either?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
santillo777
Starting Member
4 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-04 : 15:35:01
|
I'm going to move this thread to the 2005 forum and lock your new one, since it's a duplicate.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|