Can DBusers have other roles than db_owner?

Georges Oneissy

(53●5●22) Jan 12 '17, 5:26 a.m.

As audit requirement in our establishment, the fewer db_owner users on our databases, the better.

Hence my question: "Can DBusers have other roles than db_owner?"

0 votes

1 answer

1,814 views

0 votes

One answer

Permanent link

This probably depends on the Database management system. I know that DB2 has a few instance-wide authorities and more per-database authorities.

e.g.

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005478.html

We restrict our instance authorities to the instance owner or approved users, while those ID with db authority (e.g. DBADM from the above) are the ID used to make connections to database(s) for Jazz applications.

0 votes

Comments

Georges Oneissy

Jan 13 '17, 5:13 a.m.

Thanks Kevin.

We are currently using SQL 2012.

Your answer

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

clm

× 7,495

administration

× 4,716

Question asked: Jan 12 '17, 5:26 a.m.

Question was seen: 1,814 times

Last updated: Jan 13 '17, 5:13 a.m.

Can DBusers have other roles than db_owner?

Georges Oneissy

1 answer

1,814 views

0 votes

One answer

Kevin Ramer

Comments

Georges Oneissy

Your answer

Follow this question

Question details

Related questions