February 17, 2006 at 12:46 am
lets say my database is Mydb and have a user name Myuser
when i run following sql everyting goes ok on my server securitylist
but when you look at the user roperties from master level then you dont see that user is connected or have access to the database i selected
(It shown on form where you can see propertie of a user)
EXEC sp_grantdbaccess 'MyUser', 'MyUser'
GO
EXEC sp_addrolemember 'db_owner','MyUser'
so if you look myuser properties in databse security login properties you will see that myuser is connected to databse and have dbowner priviligies.
If you look from master level security login user properties you dont see
that on the form even user is connected. So WHY???
BUG?
February 17, 2006 at 6:41 am
I am losing you here. When you say master level exactly where in EM are you looking at?
February 17, 2006 at 7:05 am
Security on top level
from that level you dont see it is connected
in users level when you select your database you can see that user alreadey has these priviligies.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply