Re: SQL 2005 user limit

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/10/05 

Date: Thu, 10 Nov 2005 08:54:44 -0500

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: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Relational-to-OOP Tax
    ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
    (comp.object)
  • Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??
    ... I even had one tell me "SQL injection? ... about databases, server management, mail, or anything. ... I have a ghostwriter who keeps me active on the mailing lists. ...
    (php.general)
  • DataArchitect Version 3.5 Now On HP-UX
    ... DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions. ... Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars! ... Minimize/Maximize feature on diagram objects ...
    (comp.sys.hp.mpe)