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: user permissions in a database as a whole or tables
      ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
      (comp.databases.informix)