November 20, 2001 at 6:18 pm
Hi! All
Could someone Please clarify me as to how the object permissions are considered. For eg:A table is created in a database to which we have to set the permissions based on the user whether he is a normal user or user belonging to special group. suppose if the user should be given Select, insert and update permissions only..then it can be set. But while setting permissions from enterprise manager, there are two check boxes called "Public" and "System". so the permissions should be set to only PUBLIC or to SYSTEM or both?.If so..please mention the reason as to why. Even though it is of basic nature .I still have doubts on this topic. I would appreciate your response. I got two replies for this question previously, but no one was clear about it..as both are conflicting each others answers.
Thanks in advance
bye
Deepu
November 20, 2001 at 7:15 pm
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
November 20, 2001 at 7:53 pm
Hello! Steve
Thank you for the useful information provided.
Deepu
November 20, 2001 at 10:03 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply