SQL 2008 - Permissions problem
Hi.
I created a new Login called test. But when I connect using Management Studio.
I can connect to myDB database. But don't see the tables... I can see the system tables.
If I connect using sa - I can see ALL the objects.
What am I doing wrong. How can see the tables and using the test account?
What settings where do I need to set?
thx
I created a new Login called test. But when I connect using Management Studio.
I can connect to myDB database. But don't see the tables... I can see the system tables.
If I connect using sa - I can see ALL the objects.
What am I doing wrong. How can see the tables and using the test account?
What settings where do I need to set?
thx
Aaron Tomosky
In the properties of test on the left are the other tabs that let you assign permissions to all databases or just tspme
ASKER
I created test under SECURITY / USERS
On the tab is GENERAL, SECURABLES, and EXTENDED PROP
On the tab is GENERAL, SECURABLES, and EXTENDED PROP
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
doesn't have that
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
As a note, when using the MS supplied scripts to script out logins between servers, it does NOT add in the assigned server roles.
HTH
David
As a note, when using the MS supplied scripts to script out logins between servers, it does NOT add in the assigned server roles.
HTH
David