Prev: Sequence
Next: Query Decimal Date field for Yesterday's Records
From: bh on 8 Mar 2010 22:37
I have some stored procedures, which I've granted execute permissions to a
user for. When the user hits the stored procedures from an outside program,
it errors out stating that the permissions are required for the underlying
tables. Both the tables & the stored procedure are owned by dbo. I only
want to grant permissions on the procedures, not the individual tables.
Thanks in advance for any help. It would be greatly appreciated.

bh


From: Tibor Karaszi on 9 Mar 2010 01:20
Inheriting permissions though ownership work if:

Same owner through the chain (obviously)
Only regular DML (SELECT, INSERT, UPDATE, DELETE, MERGE)
Objects in same database
Dynamic SQL

If you don't break any of above, then I suggest you verify that the expects
login/user combination is used from your app, and also test using an
interactive login from a query window.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"bh" <sombody(a)somewhere.com> wrote in message
news:#gk0vnzvKHA.2436(a)TK2MSFTNGP04.phx.gbl...
> I have some stored procedures, which I've granted execute permissions to a
> user for. When the user hits the stored procedures from an outside
> program, it errors out stating that the permissions are required for the
> underlying tables. Both the tables & the stored procedure are owned by
> dbo. I only want to grant permissions on the procedures, not the
> individual tables. Thanks in advance for any help. It would be greatly
> appreciated.
>
> bh
>
 | 
Pages: 1
Prev: Sequence
Next: Query Decimal Date field for Yesterday's Records