Subject | Access permissions and stored procedures |
---|---|
Author | Jay Johannes |
Post date | 2001-01-23T10:41:15Z |
A table has full permissions for admin but reference only for users
A stored procedure called by users needs to access above table.
I get a permission access problem here.
Is there a way to login as a different user from within a stored
procedure to access above table?
Or could I tell inside a procedure that I am actually admin who
created the procedure in the first place anyway?
Cheers
Johannes
A stored procedure called by users needs to access above table.
I get a permission access problem here.
Is there a way to login as a different user from within a stored
procedure to access above table?
Or could I tell inside a procedure that I am actually admin who
created the procedure in the first place anyway?
Cheers
Johannes