Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Red face Unanswered: SQLServer2000 - system admin problem

    Hi,

    I have SQLServer20000 Enterprise Manager-Version 8.00 and Microsoft Enterprise Manager - V 2.0 Version 5.1 Service Pack 1 and SQL 8.00.760. A "user" owns the database and when I have the user logged to SQL Query Analyzer ( with user and pwd)
    When enable Fixed server role as system administrator for that user (owns db)
    select * from table1 says that the table does not exist
    select * from "owner".table1 gives the records.
    When enable fixed server role as security administrator for that user ( owns db)
    select * from table1 outputs records
    select * from owner.table1 outputs records.
    If I have both system administrator and security administrator checked for the user the scenario is like "system administrator" where select statement outputs records only if owner is included in the statement.

    When system administrator is the highest role why does it behave this way?

    Any help is appreciated.

    Thanks
    Vinnie

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    A databasetable consists of the name of the table and the owner who owns it. In effect: tables with the same name can co-exist if there are different owners.

  3. #3
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Then

    Thanks a bunch. Then why is it I am able to see the records when the user is "Security administrator" and not able to see when the user is "System administrator" ( which has highest permissions on server)?

  4. #4
    Join Date
    Feb 2004
    Posts
    492
    hmm, quess you already knew that I may be way of (again) but is the db a copy from some other location? I tried to recreate a similar setup but have no trouble selecting the data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •