Avatar of Zolf
Zolf
Flag for United Arab Emirates asked on

Cannot view user in the Security section of the database

Hello there,

I have a user zaj to whom i have given db_owner permission to a database but for some reason the user is not displaying in the database's security section. what could be the reason.

cheers
Zolf
Microsoft SQL ServerDatabasesWindows Server 2008Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Zolf

8/22/2022 - Mon
Brian Crowe

How did you give him db_owner permission then?  There is a difference between an instance LOGIN and a database USER.  Are you sure you don't have the former and are missing the latter?
Zolf

ASKER
Forgot to attach screenshot. this zaj I have given him sysadmin permission

1
Vikas Garg

Hi,

Select the user to which you want to get displayed at your database.

go to properties - > User Mapping - > uncheck the database and check again

Check the DB_owner and click OK.

Your user should be displayed in the user column of the database where dbo is shown currently.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Zolf

ASKER
Thanks for your feedbacks.
One thing, this user zaj is sysadmin,could be that sysadmin user is not shown in the database's - security - user folder???
the reason is when i create a new user and add map them to a db, they are added but not this user.
Also when you see that screenshot, in the user column it shows dbo instead of zaj,why??
Vitor Montalvão

Did you Refresh the Security folder after giving him db_owner rights?
Also, check the login for the dbo. He might be him already.
Zolf

ASKER
yes i did, and i still cannot get this user in that security folder
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Zolf

ASKER
Brian,

Can you please elaborate more on this in few words or refer some good article

There is a difference between an instance LOGIN and a database USER.Are you sure you don't have the former and are missing the latter?
Zolf

ASKER
I've requested that this question be deleted for the following reason:

no help
ASKER CERTIFIED SOLUTION
Brian Crowe

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Zolf

ASKER
Brian, thanks very much for your feedbacks. cheers!!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck