Post reply

Sysobjects table columns

  • July 14, 2011 at 5:52 am

    #149246

    Hello,

    What is the difference between UID and Info column of sysobjects table in SS2K?

    We have a user with sysadmin permission. A table created by this user has UID = 1 but info = 16. A table created by sa has uid = 1 but info=6.

    What is the significance of info column in sysobjects?

    Thanks

    Rohit

  • July 14, 2011 at 5:58 am

    #1352725

    http://msdn.microsoft.com/en-us/library/aa260447%28v=sql.80%29.aspx

    info: reserved, for internal use only. Hence just ignore it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 14, 2011 at 6:02 am

    #1352729

    Thanks for the link. I got this doubt because we have one application which lists the tables in a database for further processing.

    A table created by sa login was not visible to other user with sysadmin rights even though the uid for both is 1.

  • July 14, 2011 at 6:25 am

    #1352753

    SQLRO (7/14/2011)

    Thanks for the link. I got this doubt because we have one application which lists the tables in a database for further processing.

    A table created by sa login was not visible to other user with sysadmin rights even though the uid for both is 1.

    If he's really using SA access then he'll see the table. Period, end of discussion. So you might want to check the permissions on his account.

Viewing 4 posts - 1 through 3 (of 3 total)

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