Role & Permission
-
Hi Folks,
I want to create a user in MS SQLSEVER.
This user can only perform on his/her on objects.
I mean s/he can only issue DML,DDL statement on his/her on objects, not from all users.
anyone can help?
TIA,
Lux
-
- with SQLServer2005 you can perform this by granting at schema level.
- In sqlserver2000 you can only add the user to the db_owner group of the database. But then that user will have DDL-rights for _all_ objects of the database.
Therefor with sql2000 I guess having one db per user will be more suitable. You could provide a 'common' db with only views in it that point to the individual user-db-objects, so noone has to keep in mind wich db to qualify.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
In SQL Server 2000 you can also grant the CREATE <object> rights manually. This will create the objects belonging to the user. The user will have complete rights over his or her objects but won't be able to touch anyone else's unless permission is granted.
K. Brian Kelley
@kbriankelley -
oops .. overlooked that because we don't use it in that way all our dev-teams have their own databases (provided at request) and have db-ownership.
Thanks for the correction.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
>>>In SQL Server 2000 you can also grant the CREATE <object> rights >>>manually. This will create the objects belonging to the user. The user will >>have complete rights over his or her objects but won't be able to touch >>anyone else's unless permission is granted.
Yes, you are rite.
I already did that-grant create table to that user.
But I wonder why this user can only drop, create, and truncate his/her own table, yet cannot insert, update, delete that table.
This is the point that get me stuck.
TIA,
Lux
-
The user should be able to do so. As the owner of the table the user can certain grant himself/herself the permissions to this.
K. Brian Kelley
@kbriankelley -
I appreciate your assistant.
I'm now got what i want.
a lot of thanx.
Lux
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply