Viewing 5 posts - 106 through 110 (of 110 total)
Thanks your reply.
the thing is Scripting all the databases in developemnt takes around 54 mins. but in production only 6 minutes.
I just want to know what affects the performance of...
January 29, 2008 at 9:15 am
Roy Ernest (1/25/2008)
Cant you set up the objects that this User needs to alter in a seperate schema and gove Alter Schema permission for that schema?
I am using SQL Server...
January 25, 2008 at 11:09 am
I can issue "Grant Create Table to db_custom", no problem. but users only can create new table and no permission to alter tables.
When I exec "Grant Alter Table to db_custom",...
January 25, 2008 at 11:07 am
SQL ORACLE (1/25/2008)
Add the role, ddladmin, to your custom_role.
if I add ddladmin to custom_role, then users under this role will have ddladmin permission to all the tables, not only specific...
January 25, 2008 at 10:52 am
Actually I created one custom database role, named "db_Custom" and added objects to this new role.
Users under this role only have "select, update, delete,insert" on objects.
But users need to own...
January 25, 2008 at 10:06 am
Viewing 5 posts - 106 through 110 (of 110 total)