July 5, 2003 at 1:18 am
How can I get a Script for existing role.
Matter is that I make role at home, then I'm
going to my work and want to run this script.
Thank you.
July 5, 2003 at 3:37 pm
You may have to generate a script larger than intended and then extract the bit you want.
In EM, right click on DB name, All Tasks, Generate SQL Script, General tab leave asis, Formatting tab uncheck DROP, Options tab check Script database users and database roles. Then Preview from the General tab.
Cheers,
- Mark
July 5, 2003 at 10:25 pm
quote:
You may have to generate a script larger than intended and then extract the bit you want.In EM, right click on DB name, All Tasks, Generate SQL Script, General tab leave asis, Formatting tab uncheck DROP, Options tab check Script database users and database roles. Then Preview from the General tab.
Thank you. It won't do. Script which will be received is too long. Editing will take more time, than manual scripting. Is there any other way?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply