Re: SQL 2005 user limit

From: Marcin S. (MarcinS_at_discussions.microsoft.com)
Date: 11/10/05

  • Next message: Marcin S.: "Re: SQL 2005 user limit" 
    Date: Thu, 10 Nov 2005 06:55:07 -0800

    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: Marcin S.: "Re: SQL 2005 user limit"

    Relevant Pages

    • Re: SQL 2005 user limit
      ... Well those are pretty open permissions. ... Andrew J. Kelly SQL MVP ... "Marcin S." ... >> Andrew J. Kelly SQL MVP ...
      (microsoft.public.sqlserver.security)
    • Re: SQL 2005 user limit
      ... Andrew J. Kelly SQL MVP ... "Marcin S." ... > I just created two databases and two users but both users can see ... >> Andrew J. Kelly SQL MVP ...
      (microsoft.public.sqlserver.security)
    • Re: Least Level Permissions
      ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... For example restricting permissions such ...
      (microsoft.public.sqlserver.security)
    • Re: 21776 Error by EM when a view column name is changed.
      ... But restarting works too. ... > Thanks very much Andrew. ... >> Andrew J. Kelly SQL MVP ... >>> view column, and then change the name of the column, the permissions do ...
      (microsoft.public.sqlserver.security)
    • Re: Least Level Permissions
      ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... For example restricting permissions such ...
      (microsoft.public.sqlserver.security)