Why can i expand other peoples database's in sql server express?

Discussion in 'Databases' started by yasar_bhatti, May 6, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. yasar_bhatti

    yasar_bhatti

    /emoticons/mad.gif

    I can connect to my database via sql server express and do queries on it.
    However i can see other databases as well.
    I cannot expand most of the databases however there are a few that i can expand and i can see what tables and columns there are!
    Thankfully i cannot run queries on them.

    Doesn't this seem odd?
    Although i can't mess around with data, i should not be able to see what tables are in someone elses database!
    Who should i contact about this?
     
    yasar_bhatti, May 6, 2008
    #1
  2. wisemx

    wisemx

    Unless you have a dedicated SQL box that is the behavior.
    You are a trusted account when you log in, seeing is not harmful for a trusted account.
    Salute,
    Mark
     
    wisemx, May 6, 2008
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    This also depends on how other users configure their database permission. By default, you should only be able to see the list of database and you should not be able to see the table, etc.


    When a user allow "Guest" to display the table, then everyone can see it.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, May 7, 2008
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page