Re: EXECUTE Permissions and Cross Database

Yes, the login is the same in both cases.

Micky

David Browne wrote:
"Micky McQuade" <javamick@xxxxxxxxx> wrote in message
news:1153144180.968800.32910@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have an odd situation. Here are the details:

- I have three databases (A, B, C).
- I have a user that has EXECUTE and SELECT permissions on each
database.
- I have a stored procedure in A and B that does an update in C at one
point
- The stored procedure works fine from database A, but from database B,
it gives me the following UPDATE error: UPDATE permission denied on
object 'MyTable', database 'C', schema 'dbo'
- No dynamic SQL is used
- The database owners are the same as well as the table and stored
procedure owners

Can anyone help guide me on this?



Is the login executing the procedure the same in both cases? The login must
have access to database C.

David

.

Relevant Pages

  • Re: Limiting a user to only executing a stored only that access an
    ... the underlying source code) and execute a stored procedure. ... I simply gave the user login to the database and ... "What I would like is to create another database, ... Northwind using three part name qualifier. ...
    (microsoft.public.sqlserver.security)
  • Re: Limiting a user to only executing a stored only that access an
    ... the underlying source code) and execute a stored procedure. ... I simply gave the user login to the database and ... "What I would like is to create another database, ... Northwind using three part name qualifier. ...
    (microsoft.public.sqlserver.security)
  • Re: Problem with bulk load security.
    ... Then I defined the procedure using 'with execute as self'. ... As for user vs login, I don't see a syntax difference. ... database is trustworthy, you cannot get rights outside the database. ... One is to make the database trustworthy, ...
    (microsoft.public.sqlserver.security)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: Limiting a user to only executing a stored only that access an
    ... the underlying source code) and execute a stored procedure. ... I simply gave the user login to the database and ... "What I would like is to create another database, ... Northwind using three part name qualifier. ...
    (microsoft.public.sqlserver.security)