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
zolfAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
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?
1
zolfAuthor Commented:
Forgot to attach screenshot. this zaj I have given him sysadmin permission

1
0
Vikas GargBusiness Intelligence DeveloperCommented:
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.
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Learn More
zolfAuthor Commented:
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??
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you Refresh the Security folder after giving him db_owner rights?
Also, check the login for the dbo. He might be him already.
0
zolfAuthor Commented:
yes i did, and i still cannot get this user in that security folder
0
zolfAuthor Commented:
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?
0
zolfAuthor Commented:
I've requested that this question be deleted for the following reason:

no help
0
Brian CroweDatabase AdministratorCommented:
sorry, Zolf, this one slipped through the cracks for me.  Perhaps this will help in explaining the difference between a login and a user.

http://blog.sqlauthority.com/2014/07/16/sql-server-difference-between-login-and-user-sql-in-sixty-seconds-070/
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
zolfAuthor Commented:
Brian, thanks very much for your feedbacks. cheers!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.