Post reply

Another scripting problem

  • October 10, 2008 at 1:05 pm

    #192037

    Hi guys I have this requirement...

    Login A has been granted a view definition (server permission) to a sql server login B

    I know the T-SQl Code for this is below

    USE master;

    GRANT VIEW DEFINITION ON LOGIN::A TO B

    Go

    But my question is if i granted this with the GUI, how do I scipt this out?

    Thanks

  • October 10, 2008 at 2:56 pm

    #883652

    This is the requirement coz we need to script out all the security of a server and place it in a folder for our project. Can somebody reply me how i can script out all the security nothing left.

  • October 10, 2008 at 3:14 pm

    #883662

    Right click the server in SSMS and select Generate Script.

  • October 10, 2008 at 3:17 pm

    #883664

    There will be no generate script option if u right click on the server. I guess you mean to say the database but even if you use that wizard it will not provide you the complete security.

Viewing 4 posts - 1 through 3 (of 3 total)

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