Execute SP to access table with no select permissions
From: Aaron Barkel (aaron_bar@hotmail.com)
Date: 11/19/02
- Next message: juanita: "db_ddladmin database role and dbo security"
- Previous message: D. Small Gilligan: "Re: Microsoft Security Bulletin Severity Rating System Changes"
- Next in thread: Stamey: "Re: Execute SP to access table with no select permissions"
- Reply: Stamey: "Re: Execute SP to access table with no select permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Aaron Barkel" <aaron_bar@hotmail.com> Date: Tue, 19 Nov 2002 10:18:51 -0600
Here is the situation:
I recieve a subscription to a service that pushes data to a table in my DB.
Each time we recieve the push it destroys one table (refs) and recreates it.
I have a stored procedure in the DB that the public role has execute privs
on. This sp performs selects on 'refs' and returns a recordset to a VB
program. Each time we recieve the push and the table is deleted/recreated
the select permissions to the role 'public' are destroyed on the 'refs'
table. (All users are members of the public role only.) Is there a way to
execute a sp as a particular user inside Sql server 2000. Any other ideas on
how to circumvent or correct this issue?
Thanx,
A
- Next message: juanita: "db_ddladmin database role and dbo security"
- Previous message: D. Small Gilligan: "Re: Microsoft Security Bulletin Severity Rating System Changes"
- Next in thread: Stamey: "Re: Execute SP to access table with no select permissions"
- Reply: Stamey: "Re: Execute SP to access table with no select permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
