Cross database update issue

From: Viral Shah (Viral.shah_at_intel.com)
Date: 07/26/03 

Date: Fri, 25 Jul 2003 17:34:24 -0700

>From a store procedure, I am trying to update database
table in other database.

Here is how it's setup

Database Name: Test
======================
User Name: Test1 Role Name=Test
Role Test has select permission to table t_test

Database name: Test1
========================
User Name: Test1 Role Name=Test
User Name: Test1 Role Name=Test
Role test has execute permission for sp_test

store procedure code:
create procedure sp_test
as
update test..test
set ctime=getdate()

When I execute sp_test in Test1 db I am getting update
permission denined
UPDATE permission denied on object 'test',
database 'test', owner 'dbo'.

This code used to work before..Can you help.

Relevant Pages

  • Re: Cross database update issue
    ... Also, for dbo-owned objects, the owner of both databases must be the ... You can execute sp_helpdb to determine the current database owners. ... > User Name: Test1 Role Name=Test ... > Role Test has select permission to table t_test ...
    (microsoft.public.sqlserver.security)
  • Re: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.conversion)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.security)
  • Re: Windows Power User SQL
    ... The guest user must have connect permission in master and tempdb. ... When I run from the master database for example testing against user bill ...
    (microsoft.public.sqlserver.security)