Re: Permissions Across Databases
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 6 Feb 2008 08:06:52 +0200
Hi
Is the user an owner of both databases?
"Flyguy" <flyguy@xxxxxxxxxxxxx> wrote in message
news:21B37B70-78BA-446B-87E8-159DBB8140A0@xxxxxxxxxxxxxxxx
I have two databases. In the first database I have a view that needs to be
able insert into a table in the second database. I want the user to only
have select permissions in the second database?s table. Because of this
restriction the view cannot insert into the table when the user inserts
into
the view. Is there some way of granting the view insert permissions to
the
table? I know this will work if the view and table are in the same
database
but I have to have them in different databases in this situation.
.
- Prev by Date: Cross-database execution permissions with certificates and schemas
- Next by Date: Re: sql2k5/w2k3 Changing sql login password?
- Previous by thread: Re: Permissions Across Databases
- Next by thread: sql2k5/w2k3 Changing sql login password?
- Index(es):
Relevant Pages
|
