Re: SELECT permission denied on MSDB

From: Alli K (anonymous@devdex.com)
Date: 03/06/03

  • Next message: Dave: "Secure client-db-connection" 
    From:     Alli K <anonymous@devdex.com>
Date: Thu, 06 Mar 2003 14:45:34 -0800

    Thanks for your Reply, but this hasn't fixed the problem. The SQL Server
    is a named instance. Could this have any effect on permissions? I am
    grasping at straws here.
    Thanks.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!

  • Next message: Dave: "Secure client-db-connection"

    Relevant Pages

    • ADP, Application Role, and objects
      ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
      (microsoft.public.access.adp.sqlserver)
    • Re: field level security question
      ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
      (microsoft.public.sqlserver.security)
    • Re: Deny access to all users (including Administrator and DomainAd
      ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
      (microsoft.public.sqlserver.security)
    • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
      ... functionality using our WinForm app and read-only functionality using ... SQL Server permissions are not application-aware. ... App1 contains CRUD functionality using stored procs (EXEC perms on ...
      (microsoft.public.sqlserver.security)
    • change a named instance to default instance
      ... Produced By Microsoft MimeOLE V6.00.2800.1441 ... even though there is only one SQL Server ... | Is there anyway I can make my named instance behave like the default? ... Configure an Alias by Using TCP/IP Sockets ...
      (microsoft.public.sqlserver.connect)