Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-21 : 20:56:03
|
kiran kambhampati writes "Hi ,
this is with regards to sql server 2000 on windows 2k..
1. how can i allow some users to look at the design of a table without allowing them to modify it..In other words, what are the roles that i can avail to accomplish this.. i tried to give them the public role that gives them permission to select, update and delete data, but, it would be nice if they could look at the design of the table and not allowing them to make any changes..are there any system roles that i can use to accomplish this task or do i have to create new roles??
2. Also , can anybody tell me how to go about creating schemas for different users that allows them to create and test their stored procedures or other functions in their own schema, without actually doing anything in the actual database.. i dont want my users to meddle with the actual database file...
thanks in advance..kiran" |
|
|
|
|
|
user roles