Permission Problems for Newbies

From: Nobody (nobody_at_nospam.com)
Date: 09/22/04

  • Next message: Jonas Larsen: "ODBC/Access issue" 
    Date: Wed, 22 Sep 2004 12:19:14 +0800

    How can I:

    1. Grant a user for viewing all store procedure on a database without modify
    or execute

    2. Grant the user permission to view one store procedure on a database but
    not the other SPs

    3. Job history: Can I grant the user permission to view job content and/or
    history on a particular job but not others

    Thanks.

  • Next message: Jonas Larsen: "ODBC/Access issue"

    Relevant Pages

    • Thank you very much...again
      ... Sue: ... the grant select on tempdb will ... not work if the store procedure is in master database. ... The way I did it is to create the store procedure in the ...
      (microsoft.public.sqlserver.security)
    • Re: Create SQL Db on SQL server
      ... Thankyou Robert, so i just make "Initial Catalog=master"? ... and could you mind explain more a bit how to grant the user permission in ... the Initial Catalog can't point to a database that does ... once you create the database you will have to grant the user ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Thank you very much...again
      ... exists in tempdb so all users have access to tempdb through ... database which would avoid some of this. ... the grant select on tempdb will ... >not work if the store procedure is in master database. ...
      (microsoft.public.sqlserver.security)
    • Re: Permission Problems for Newbies
      ... Users can execute sp_helptext to view the text of stored ... Grant a user for viewing all store procedure on a database without modify ...
      (microsoft.public.sqlserver.security)
    • Re: No db access after publishing web site
      ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
      (microsoft.public.dotnet.framework.aspnet)