Re: Table OWNER

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 12/22/04

  • Next message: John Bell: "Re: To DMZ or not DMZ" 
    Date: Wed, 22 Dec 2004 15:29:35 -0000

    Hi

    "Saradhi" <upadrasta@inooga.com> wrote in message
    news:OfVRfVD6EHA.3504@TK2MSFTNGP12.phx.gbl...
    1) Wts the query to know the Owner of a table?

    Select * FROM INFORMATION_SCHEMA.TABLES
    WHERE TABLE_NAME = '<Table Name>'

    2) I logged in as a user pardha whose server role is a system administrator.
    I created a table in the SQL Enterprise Manager and SQL Query Analyser, but
    the EM shows the owner of the Table as dbo. it should show as pardha as I
    created it. Is there anything wrong in my thinking?

    As you are (probably) a member of the sysadmin fixed server role you will be
    mapped onto dbo.
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_9qyh.asp

    John

    -SARADHI

  • Next message: John Bell: "Re: To DMZ or not DMZ"

    Relevant Pages

    • Error joining tables from separate dbs using SqlCommand object
      ... is the owner of table Portal_Users dbo? ... The query is like this: ... When I attempt this, I get "Invalid object ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: newbie, querie help/advice
      ... > user3 has read access to both tables. ... First, above query will fail because you qualify the column name with dbo, and you didn't alias the ... Dbo is a user that exists in every database, the database owner. ...
      (microsoft.public.sqlserver.programming)
    • Re: Table OWNER
      ... If you don't specify the owner then it will look for an object owned by the current user, if that does not exist it will look for one owned by dbo. ... I created a table in the SQL Enterprise Manager and SQL Query Analyser, ...
      (microsoft.public.sqlserver.security)
    • Re: Object permissions
      ... Who is the owner of the query? ... permissions does the owner have on the underlying tables? ... does the user have on the query; ... to 'owners' in the sql statement each time the code runs, ...
      (microsoft.public.access.security)
    • Re: ADP: Cant use stored procedure on remote SQL server
      ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure. ...
      (microsoft.public.access.adp.sqlserver)