Re: permission to review jobs and settings

From: Joshua Heslinga (jheslinga@attbi.com)
Date: 09/04/02 

From: "Joshua Heslinga" <jheslinga@attbi.com>
Date: Wed, 4 Sep 2002 06:06:49 -0400

Thank you for responding, but I'm a little confused. I understand that you
can assign read-only types of permissions on tables. But can you be more
specific about whether there's a way to grant read-only access in the 2
specific instances (jobs and logins) that I mentioned?

"[MS] Hai-Wei Xu" <haiwxu@online.microsoft.com> wrote in message
news:eM0YrEAUCHA.2336@cpmsftngxa08...
> Hi Joshua,
>
> For example, you could run "sp_helptext sp_helplogins" to check the tables
> which need to be queried, and then grant the permissions to the user. Some
> stored procedures will call other system stored procedures. If you need to
> run these SP, you might also need to grant the additional permission.
>
> This posting is provided 'AS IS' with no warranties, and confers no
rights.
>
> Regards,
> Haiwei Xu
>

Relevant Pages

  • RE: permission to review jobs and settings
    ... and then grant the permissions to the user. ... stored procedures will call other system stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Execute permission for all sprocs
    ... I am looking to write a script that will grant a specified user execute ... access to all stored procedures, but no other permissions ...
    (microsoft.public.sqlserver.security)
  • Re: Granting create table to database role
    ... In our company we gave permissions only for EXECUTION on stored procedures ... If you want the users to be able SELECT/UPDATE/DELETE/INSERT don't grant ...
    (microsoft.public.sqlserver.security)
  • Re: Preventing unauthorized access
    ... Use only stored procedures to access the database in your application. ... not grant any permissions on tables or views to users; ... permissions on stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: USERS group has the ability to change security permissions???
    ... Please use the Advance view in the NTFS permissions dialog to ... When there is a generic grant and a special grant to the same entity ... the RESULT: user level access can change NTFS ...
    (microsoft.public.win2000.security)