System Stored Procedure Permissions

From: Rodger (anonymous_at_discussions.microsoft.com)
Date: 11/11/03 

Date: Tue, 11 Nov 2003 11:01:16 -0800

Hi

I have system stored procedures in a databse
starting with
dt_adduserobject_vcs
dt_checkinobject_u
dt_displayoaerror_u
dt_droppropertiesbyid
...
...
...

somehow instead of showing the owner as dbo and type as
system in Enterprise Manager it displays owner as user
and type as user, I can also view the stored procedures
and can modify them which is not the case in other
database.

any clue...you can find the system stored procedure in all
databases.

Relevant Pages

  • Re: using sp_ as a naming convention for stored procedures
    ... System stored procedures are created and stored in the master ... database and have the sp_ prefix. ... SQL Server always looks for a stored procedure ...
    (microsoft.public.sqlserver.programming)
  • Re: system stored procedures
    ... The stored procedures sp_MSdbuserpriv and sp_MSuseraccess ... legitimate system stored procedures. ... >standard login, give that login access to the user ... >database and also default the login to the user database. ...
    (microsoft.public.sqlserver.security)
  • Re: database ownership
    ... "Raks" wrote in message ... > I have a database which has stored procedures which have an owner by the name ... How do I change the ownership of these stored procedures to dbo ...
    (microsoft.public.sqlserver.server)
  • Re: database ownership
    ... "Raks" wrote in message ... > I have a database which has stored procedures which have an owner by the ... How do I change the ownership of these stored procedures to ...
    (microsoft.public.sqlserver.server)
  • Change Stored Procedure object owners for hundreds of objects
    ... Is there a quick way to change the owner of all the stored procedures in a ... TIA! ...
    (microsoft.public.sqlserver.programming)