Post reply

Is objectownership to be found in systemtables?

  • September 16, 2005 at 6:40 am

    #95237

    In EM I can see the owner of a db-object. I think this info must be found somewhere in systemtables, but where? I can find several columns related to ownership, but none sofar tells me, who actually wons the object.

    Any hints apreciated.

    Greetz,
    Hans Brouwer

  • September 16, 2005 at 6:55 am

    #590537

    Select name, user_name(uid) as Owner from dbo.SysObjects order by name

  • September 16, 2005 at 6:59 am

    #590541

    In case you meant the owner of the db >>

    select name, suser_sname(sid) as owner, convert(nvarchar(11), crdate) as CrDate from master.dbo.sysdatabases

  • September 19, 2005 at 4:26 am

    #590871

    Tnx for the heads up. Could have thought that 1 up myself...

    Greetz,
    Hans Brouwer

  • September 19, 2005 at 7:09 am

    #590899

    So which one did you actually need??

  • September 19, 2005 at 8:09 am

    #590956

    Objectowner, not db-owner

    Greetz,
    Hans Brouwer

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply