It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,457
×4,711

question asked: Jan 12 '17, 5:26 a.m.
question was seen: 1,670 times
last updated: Jan 13 '17, 5:13 a.m.

Related questions

Can DBusers have other roles than db_owner?

0
Georges Oneissy (53●5●22) | asked 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?"

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kevin Ramer (4.5k●9●186●201) | answered Jan 12 '17, 11:07 a.m.

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.

Comments
Georges Oneissy commented Jan 13 '17, 5:13 a.m.

Thanks Kevin.


We are currently using SQL 2012.

Your answer

Register or to post 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.