Post reply

problem in creating new user

  • November 15, 2010 at 2:10 am

    #228796

    hi created a new user in this way

    1.open the SSMS

    2.under Security ---> Login --> Right click and selcted New Login

    3.Login Windows open given the login name "user123" and selected SQL Authentication given password

    4.Checked only the "Enforce password policy" and deselected the other 2 options

    5.Under Default Database drop down list selected the DB which i want to give to the user

    6.Now in the Server Roles by default it is selected to "public"

    7.In the User Mapping Selected the DB name and selected the schema "dbo"

    8.under Database role membership selected "db_datareader" and press ok.

    9.Under the Database ---> Security --->users the new user is created

    the problem is when i open the Programmability --> Stored procedures only the system procedure is seen no user defined procedures. I ca view all the tables but no user defined proc.

    Is I am missing any thing. pls help

    thanks in advance

  • November 15, 2010 at 2:43 am

    #1250592

    The user needs to have view definition permission on the stored procedures.

    GRANT VIEW DEFINITION ON SCHEMA::dbo TO UserName

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 15, 2010 at 5:21 am

    #1250636

    thanks pradeep it really worked...can we do this task from SSMS without writing query

  • November 15, 2010 at 6:21 am

    #1250658

    SSMS --> Database --> User Properties --> Securables --> Search

    In the "Permissions" tab select the permissions that needs to be granted on the object

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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