| Author |
 Topic  |
|
|
santillo777
Starting Member
4 Posts |
 Posted - 06/04/2008 : 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. |
Edited by - tkizer on 06/04/2008 15:35:23
|
|
|
tkizer
Almighty SQL Goddess
USA
35020 Posts |
|
|
santillo777
Starting Member
4 Posts |
Posted - 06/04/2008 : 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
USA
35020 Posts |
|
|
santillo777
Starting Member
4 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35020 Posts |
|
| |
Topic |
|
Missing sysuser record
