Avatar of Pau Lo
Pau Lo
 asked on

db_dataowner priveleges

Can I ask for some specific scenarios when a user would require db_dataowner privileges? I am looking at security permissions and have quite a number of users with db_dataowner over a few databases, but before asking for that to be removed, it would help knowing any particular reasons why that level of access may be required. For info none of the users are DBA's! But some do have systems admin responsibility for the over-arching applications which use these databases for records storage.
DatabasesMicrosoft SQL Server

Avatar of undefined
Last Comment
Jose Torres

8/22/2022 - Mon
dfke

Hi,

users with the db_owner role can basically do anything with the database, alter users roles and even remove it. The sysadmin role sits on top of that and doesn't need to have db_owner privileges. Regular users should not be a member of this role. Just give db_read and db_write so those users are able to alter data.

Cheers
ina_don

Hi,

I think you need to look at the applications that they use and what functionality they have in the DB. This could have been someone who didn't want to go into the trouble of securing the application properly if users are authenticated directly to the DB. If each user that is granted to the application has an account on the DB, then to make sure they can work properly, you'd need to setup correct permissions for them to read/write data, execute stored procedures and access views and functions.
ASKER CERTIFIED SOLUTION
Jose Torres

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.
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