Re: check rights for executing stored procedure not for logged user
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/29/02
- Next message: Duncan Isley: "Using SQL username as criteria on a view"
- Previous message: Thomas Münzer: "check rights for executing stored procedure not for logged user"
- In reply to: Thomas Münzer: "check rights for executing stored procedure not for logged user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Wed, 29 May 2002 07:05:55 -0600
Take a look at the permissions function in books online.
IF PERMISSIONS(OBJECT_ID('YourStoredProc')) &0x20 = 0x20
PRINT 'The current user can execute.'
ELSE
PRINT 'The current user does not have permissions to
execute'
-Sue
On Wed, 29 May 2002 04:57:35 -0700, Thomas Münzer
<t.muenzer@mkl-gmbh.de> wrote:
>I need to check weather user X with password Y has the
>right to execute a special stored procedure.
>The problem is that I need to check this while user A is
>logged in.
>Is there a way to do this ?
- Next message: Duncan Isley: "Using SQL username as criteria on a view"
- Previous message: Thomas Münzer: "check rights for executing stored procedure not for logged user"
- In reply to: Thomas Münzer: "check rights for executing stored procedure not for logged user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
