Database Rights

Question

Post reply

Database Rights

ogb

SSC Veteran

Points: 211
More actions
August 24, 2010 at 3:53 pm

#237091

Hello
On my MS Sql server I have two database
Both have User zitouch
Both seems to have same permission for zitouch
If I start Management studio with Windows Authentication I can open and browse the two database
If I start Management studio with SQL Authentication and Login "zitouch" I can open and browse ONE of the two database but I can't even open the other
What can be the difference ?

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

ogb SSC Veteran Points: 211 More actions · Answer 1

Hello

I think I've found something

The user on the fault DB have no Login !

How can I add a login to a user ?

Jeffrey Williams SSC Guru Points: 90350 More actions · Answer 2

You can use sp_change_users_login to fix orphaned users. There are different parameters - so you'll need to look it up in BOL for the exact parameters you'll need.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

As posted http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149244, you almost certainly have an orphaned login. Common when restoring a DB on a different instance. Hit google (or your favourite search engine) and search on that term, there's lots and lots written and the fix is trivial.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass