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 |
|
Weicheng
Starting Member
5 Posts |
 Posted - 2009-08-21 : 11:07:41
|
| I created a schema in [database]>security>schemas and assigned a group by user to be the owner of the schema. To create specific permission for the schema, I right click on the schema and property, and go to permission pane,added the user group and ticked grant permission : execute, insert, select, update and click OK. The problem is when I reopen schema's property, all the permission (user and explicite permission ) have disapeared.Do any one know why?Much apprieciated.Wei |
|
|
|
|
|
Assigning sql 2005 schema permission