Re: App roles and linked servers...

From: Mary Chipman (mchip_at_nomail.please)
Date: 11/03/03


Date: Mon, 03 Nov 2003 10:47:56 -0500

App roles are defined for a specific database only. They can access
other databases only through the guest user account in the target
database.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Mon, 3 Nov 2003 07:02:21 -0800, "Yoel" <yolousa@hotmail.com> wrote:

>I'm trying to access data in a linked server while using
>application roles. It runs fine with Windows
>authentication, but once the application role is activated
>an error is returned stating no mapping exists for the
>user even though the login IS mapped to a remote user. For
>security reasons I cannot set a default user mapping. Can
>anyone please help?



Relevant Pages

  • Re: Snapshot Agent account rights
    ... I select Login Properties for a domain account and select User Mapping. ... User, group, or role 'dbo' already exists in the current database. ...
    (microsoft.public.sqlserver.replication)
  • User Mapping Reset Itself
    ... And in the User Mapping setting, I have assigned the login to ... a database. ...
    (microsoft.public.sqlserver.setup)
  • Re: Checking for blank rows in database - with apologies to Norman Jon
    ... Define a name ("MyDatabase") for the database area, ... Private Sub Worksheet_Change(ByVal Target As Range) ... Dim rng2 As Range ...
    (microsoft.public.excel.programming)
  • Re: database migration
    ... database size ... write rate of source and target database storage subsystems. ... If your downtime window is large enough, simply copy a cold backup set ... online redo logs to target host ...
    (comp.databases.oracle.server)
  • Re: data migration question. source & target tables are the same-
    ... database into another, bigger, more centralized database in order ... 2 fields in each source table record will need to be populated using data items appearing in other tables of the target database. ... (we will be ousting the source table key of SSN, replacing it with a more benign key item). ...
    (comp.databases.oracle.tools)

Quantcast