Re: SQL 2005 user limit

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

Date: Thu, 10 Nov 2005 08:01:06 -0800

Hi,

I did find it the database must be owned by the user.

-----------------------
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.
> >>
> >>
> >>
>
>
>

Relevant Pages

  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Fill Factor
    ... Well the only way it would go back to 90 is if someone or something is reindexing with a different fill factor. ... Andrew J. Kelly SQL MVP ... > database, i deployed a database to a client and sit the Fill Factor for ...
    (microsoft.public.sqlserver.setup)
  • Re: DataBase
    ... Andrew J. Kelly SQL MVP "Andrew J. Kelly" wrote in message ... Sorry I don't know anything about> dbase being supported with windows other than there are odbc and possibly> oledb drivers for it now, ... What I actually need to>> know>>>> is it posible to create this as a database and create tables in it, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: different environment fails to fill a dataset
    ... Are you sure that the login on the Test system has the database Planit as ... Andrew J. Kelly SQL MVP ... on the test workstation but not my development station. ...
    (microsoft.public.sqlserver.clients)