Re: SQL 2005 user limit
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/10/05
- Next message: Don Grover: "Re: Recommended Approach"
- Previous message: Marcin S.: "Re: SQL 2005 user limit"
- In reply to: Marcin S.: "Re: SQL 2005 user limit"
- Next in thread: Marcin S.: "Re: SQL 2005 user limit"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 10 Nov 2005 14:53:02 -0500
Well those are pretty open permissions.
-- Andrew J. Kelly SQL MVP "Marcin S." <MarcinS@discussions.microsoft.com> wrote in message news:FB7637DD-963C-42F2-8EB2-22704875BDDC@microsoft.com... > db_reader > db_writer > db_owner > > > > > -- > ----------------------- > Marcin S. > > > "Andrew J. Kelly" wrote: > >> What permissions do these users have? >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Marcin S." <MarcinS@discussions.microsoft.com> wrote in message >> news:34EA31D1-6F12-4212-962E-0DEC79DD3428@microsoft.com... >> > Hi, >> > >> > I just created two databases and two users but both users can see >> > eachothers >> > databases. Is there eny example on technet/msdn? >> > >> > -- >> > ----------------------- >> > Marcin S. >> > >> > >> > "Andrew J. Kelly" wrote: >> > >> >> I assume you meant it wasn't possible in SQL2000? Yes it is possible >> >> in >> >> 2005. As a matter of fact by default a user will only see objects >> >> that >> >> they >> >> have permissions to. This even pertains to things like SQL Agent. If >> >> the >> >> user is not a member of one of the Agent roles they won't even see the >> >> Jobs >> >> node. You can even filter what objects you do see even if you have >> >> the >> >> permissions to view them. >> >> >> >> -- >> >> Andrew J. Kelly SQL MVP >> >> >> >> >> >> "Marcin S." <MarcinS@discussions.microsoft.com> wrote in message >> >> news:93FD6DFA-DB57-4413-8C01-8EF038246FD1@microsoft.com... >> >> > Hi, >> >> > >> >> > In SQL 2005 it was not possible to limit a user to list all >> >> > databases >> >> > is >> >> > it >> >> > possible in SQL 2005? I cant fid any info about this issue. >> >> > >> >> > Main problem: a user should anly see hes/her own database >> >> > >> >> > (this is supported by MYSQL for long time now) >> >> > >> >> > >> >> > -- >> >> > ----------------------- >> >> > Marcin S. >> >> >> >> >> >> >> >> >>
- Next message: Don Grover: "Re: Recommended Approach"
- Previous message: Marcin S.: "Re: SQL 2005 user limit"
- In reply to: Marcin S.: "Re: SQL 2005 user limit"
- Next in thread: Marcin S.: "Re: SQL 2005 user limit"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
