Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User can't find own Tables with Sysadmin role

Status
Not open for further replies.

harrywartig

Technical User
Joined
Dec 21, 2001
Messages
1
Location
DE
Hi

Hi i have a Database an a SQL User to Access it. My SQL User "appuser" has no Serverroles and is DBO of the Database "dbapp". He is objectowner of all user tables "dbapp.appuser.TableName". Now i've grant the User the sysadmin role. Now he has no access on his own Tables: Statement:

use dbapp
Select * from TableName

if i try:
use dbapp
Select * from appuser.TableName

it Works. --> Why???





 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top