Post reply

script needed

  • September 6, 2013 at 1:29 am

    #298543

    Hi ,

    Can any one send me the script of this scenario

    I would like you to develop a script that creates a SQL user and sets the password (to be set as part of script, maybe in a parameter).

    The script will also create schema and the schema will be bound to the sql account being created and provide read only access to the table objects

    Thanks.

  • September 6, 2013 at 2:00 am

    #1647944

    You'll be learning much more if you try to create it yourself. If you run into problems we are glad to help.

    SSMS has quite good scripting technology inside. So open SSMS and do your actions in the GUI. Just before hitting the [OK] or [APPLY] button you create the script with the [Script]->"Script action to new query window" option.

    This will give you a good start to create your final code. You only have to parameterize several options and wrap the generated code inside a stored procedure.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply