enrique_aeo
asked on
create database user - with all the permissions?
in my work, I have a database user that belongs to the sysadmin role: it_support
When I create database user, these are created with all permissions, ie can view tables, run store procedure
My question is: why are they created with all the permissions?
In my house when I connect with my administrator account does not happen the same
When I create database user, these are created with all permissions, ie can view tables, run store procedure
My question is: why are they created with all the permissions?
In my house when I connect with my administrator account does not happen the same
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have to give us the exact commands you are using in the 2 scenarios you are describing so we can try to figure out what is happening in side SQL when it creates those Users/Logins for you.
it is possible this login is added to DB users via script - or was in DB before
and if login is SA Role member it can see all these anyway
and if login is SA Role member it can see all these anyway
Unless you tell us how the user is being created only thing we can do is guess.
And for now best guess is that users are being created using a script/stored procedure that might add all those permissions.
And for now best guess is that users are being created using a script/stored procedure that might add all those permissions.
ASKER