RE: System Stored Procedure Permissions

From: Gary Whitley [MSFT] (garyw_at_online.microsoft.com)
Date: 11/24/03 

Date: Mon, 24 Nov 2003 21:03:45 GMT

Hi Rodger,

The stored procedures you reference are created when you create a diagram
in a SQL Server database. I tested the stored procedures on my server and
they are created as 'System' stored procs with DBO as the owner.

I do not suspect this will cause any issues for you within SQL Sever, but
it is interesting the owner is not DBO.

Please let me know the version number of your SQL Server. Execute SELECT
@@VERSION against the server and let me know the results.

Thank you.

Gary Whitley

This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: User names
    ... > With SP3 will tables created by upsizing from access also be dbo owned as ... >>dbo by default. ... byjust specifically giving the owner name in QA. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: DBO Best Practices
    ... lines of always owner qualifying objects... ... someone who are just "a" dbo. ... > doesn't explicitly reference the object's owner (because SQL Server will ... The startup account defines the ...
    (microsoft.public.sqlserver.security)
  • Re: Allowing Fully Qualified Queries
    ... If the owner is dbo you can ... When preforming a select I'm supposed to be able to refer> to a database table in the from clause by it's fully qualified name> eg.> ... > How can SQL Server be configured to allow me to specifiy a database table> by it's fully qualified name? ...
    (microsoft.public.sqlserver.setup)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Confused about dbo
    ... Jasper Smith (SQL Server MVP) ... > database within a SQL Server instance. ... > There are several ways you could have the username dbo. ... > the true owner of the database. ...
    (microsoft.public.sqlserver.security)