Re: PREVENTING ACCESS

From: AJAY R (dba_pune_at_hotmail.com)
Date: 05/26/03

  • Next message: Usman: "powerfull user"
    Date: Mon, 26 May 2003 12:39:41 +0530
    
    

    Thanks a lot ,
    will application role help me in this . Can i Use app role as part of sql
    server secutiy .

    Regards
    Ajay
    "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
    message news:eRHtmRPIDHA.4048@tk2msftngp13.phx.gbl...
    > > is there any way to prevent users from using query analyzer .
    >
    > Don't install it on their computers, use Windows security to prevent using
    > some applications, use SQL Server security to prevent users executing the
    > query succesfully even if they get access to Query Analyzer.
    >
    > --
    > Dejan Sarka, SQL Server MVP
    > FAQ from Neil & others at: http://www.sqlserverfaq.com
    > Please reply only to the newsgroups.
    > PASS - the definitive, global community
    > for SQL Server professionals - http://www.sqlpass.org
    >
    >


  • Next message: Usman: "powerfull user"

    Relevant Pages

    • RE: Fulltext failure on a 2 node cluster
      ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
      (microsoft.public.sqlserver.clustering)
    • Re: HELP PLEASE ~ ???
      ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Multi-Channel Raid VS SAN Storage
      ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
      (microsoft.public.sqlserver.setup)
    • Re: Multi-Channel Raid VS SAN Storage
      ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
      (microsoft.public.sqlserver.setup)
    • RE: How do I get back to base SQL server on my SBS 2003 server?
      ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
      (microsoft.public.windows.server.sbs)