Object Permisssions

Question

Object Permisssions

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739541 More actions · Answer 1

I'll try to be clear and concise.

Public and System are roles, similar to groups in network administration. You can assign rights to either, both, or neither. I recommend neither and create your own role. Assign rights to the role and then users to the role.

Object permissions are select, execute, insert, update, and delete.

Some references:

http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp

http://www.sqlservercentral.com/columnists/awarren/sqlpermissionspublicrole.asp

http://www.sqlservercentral.com/columnists/sjones/wp_userrights.asp

Pls post if this is not clear.

Steve Jones

steve@dkranch.net

Guypreach SSC Enthusiast Points: 163 More actions · Answer 2

Hello! Steve

Thank you for the useful information provided.

Deepu

Steve Jones - SSC Editor SSC Guru Points: 739541 More actions · Answer 3

You are welcome. Hope it helps.

Steve Jones

steve@dkranch.net