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

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