Re: New user with no permissions can see and execute system stored procedures...

Jan
Perhaps this may help you
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/151b7a2e-ab97-42ba-baf0-6929c5334e29.htm





"Jan Nielsen" <jan_a_bilinfo.dk> wrote in message
news:ugldrlaAHHA.5060@xxxxxxxxxxxxxxxxxxxxxxx
Hi all
Using SQL Server 2005, I create a new server login (logged in as sa) and
map it to a database user and set its default schema to dbo.

Now when I open the database the newly created user is able to see (in SQL
Server Management Studio GUI) and execute _system_ stored procedures. All
user created stored procedures can neither be seen nor executed.
I have only tried to execute sys.sp_catalogs, but in my opinion a new user
should only have the right to connect and nothing else.

Does anyone know how to remove the permssion to see and execute system
stored procedures?

(I tried to delete the guest account but got an error saying that it could
not be deleted but it was disabled in the database).

Best regards

Jan Nielsen



.

Relevant Pages