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 |
|
dlorenc
Posting Yak Master
172 Posts |
 Posted - 2009-06-16 : 15:46:22
|
| If I give a user a db_owner role, and select a certain owned schema, will they only be able to act as owner for tables in that schema?..or does the concept of db_owner go up to the database and not relate to the schema?BackgroundI have a developer on my project who is working on sharepoint infopath forms, writing directly to a sql table...he needs a 'test' table to write to... because of the firewall issues, it would be onerous to set up a sql test environment and provide network access to the sharepoint enterprise server...so..can I create a 'test' schema (which would partition him from my dbo operational tables) and give him owner rights (or datawriter rights for that matter), under the test schema?... |
|
|
|
|
|
SQL 2005 SSMS, Security, Schema and Roles