November 15, 2010 at 2:10 am
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
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
thanks pradeep it really worked...can we do this task from SSMS without writing query
November 15, 2010 at 6:21 am
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