RE: permission to review jobs and settings

From: [MS] Hai-Wei Xu (haiwxu@online.microsoft.com)
Date: 08/30/02 

From: haiwxu@online.microsoft.com ([MS] Hai-Wei Xu)
Date: Fri, 30 Aug 2002 08:43:09 GMT

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

  • 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: permission to review jobs and settings
    ... can assign read-only types of permissions on tables. ... > which need to be queried, and then grant the permissions to the user. ... > stored procedures will call other system stored procedures. ...
    (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)