hi,
in my sql server 2005, i've created a new user as "test".
and i gave permission to "test" user, a database called "demo".
and default schema as "dbo".
after that when i login by using "test", i am only viewing the table object present in the demo database, not all the stored procedure.
I wants to see all the stored procedure present in the demo database.
thanks in advance,
"If you Dream it, You can Do it......."