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 |
|
viola89
Starting Member
2 Posts |
 Posted - 2013-11-17 : 06:04:29
|
| hello :)please help me. i am not DB admin, and have no idea how to solve my problem: in a DB i have 2 schemas: A and B. B schema's procedures use A schema's procedures. so I have to create user that will not be able to see A schema, but if the one uses B schema's procedures that use A's procedures - there must not be any problems... with best regards,Violet ;) |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-11-17 : 06:35:09
|
| For the most part, you should not need to do anything special. Grant execute permission to the stored proc in schema B, and "ownership chaining" will take care of things. There are some exceptions - if you have truncate table statements, dynamic SQL etc. Other than that, you are good to go. Read up a bit on ownership chaining. E.g. http://technet.microsoft.com/en-us/library/aa905173(v=sql.80).aspx |
 |
|
|
viola89
Starting Member
2 Posts |
Posted - 2013-11-18 : 02:27:00
|
| ? something like this:CREATE USER testuser WITH PASSWORD = 'Aa123456'GRANT EXECUTE ON Schema:: B TO testuserwith best regards,Violet ;) |
|
|
|
|
|
|
user's permissions on schema