Login Confusion

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Stevie D
    #1

    Login Confusion

    Hi,

    I am Just beginning to get to grips with SQL Server v 7 security on a stand
    alone win 98 PC.

    I have created a login which only has access to the pubs database and when I
    try and connect to any other database (while using this login) I am
    correctly told that I don't have access. However, Enterprise Manager does
    not request a login and therefore the log in seems to grant full access to
    every database.

    How can I get Enterprise Manager to request a log in?

    Thanks.


    Tags: None
    • Erland Sommarskog
      #2
      Re: Login Confusion

      Stevie D (Steve@127.0.0. 1) writes:[color=blue]
      > I have created a login which only has access to the pubs database and
      > when I try and connect to any other database (while using this login) I
      > am correctly told that I don't have access. However, Enterprise Manager
      > does not request a login and therefore the log in seems to grant full
      > access to every database.
      >
      > How can I get Enterprise Manager to request a log in?[/color]

      Right-click the server and select Edit Registration properties. There
      is a checkbox for always being prompted.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server SP3 at
      Microsoft SQL Server
      http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
      Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

        Comment

        • Stevie D
          #3
          Re: Login Confusion

          Thanks Erland

          This worked fine

          "Erland Sommarskog" <esquel@sommars kog.se> wrote in message
          news:Xns960F305 E4DBEYazorman@1 27.0.0.1...[color=blue]
          > Stevie D (Steve@127.0.0. 1) writes:[color=green]
          > > I have created a login which only has access to the pubs database and
          > > when I try and connect to any other database (while using this login) I
          > > am correctly told that I don't have access. However, Enterprise Manager
          > > does not request a login and therefore the log in seems to grant full
          > > access to every database.
          > >
          > > How can I get Enterprise Manager to request a log in?[/color]
          >
          > Right-click the server and select Edit Registration properties. There
          > is a checkbox for always being prompted.
          >
          >
          > --
          > Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
          >
          > Books Online for SQL Server SP3 at
          > http://www.microsoft.com/sql/techinf...2000/books.asp[/color]


            Comment

            Previous template Next
            Working...