Re: Application roles Please Help!

From: Magnus Pettersson (magnus@businessvision.se)
Date: 01/14/03 

From: "Magnus Pettersson" <magnus@businessvision.se>
Date: Tue, 14 Jan 2003 01:01:44 +0100

If I do this I get
Server: Msg 916, Level 14, State 1, Procedure TestViewMP, Line 3
Server user 'Conn2000' is not a valid user in database 'MDB_TAB_01'.

This is due to the Application role
I have a view called TestViewMP
looks like
CREATE VIEW dbo.TestViewMP
AS
SELECT *
FROM MDB_TAB_01.dbo.AAR
Granted to the Application role

Magnus

"Pura" <pn2kt@yahoo.com> wrote in message
news:rPFU9.612$M%5.439875740@newssvr11.news.prodigy.com...
> create your views as dbo then grant select to the App role. The remote
table
> should also be owned by dbo.
>
> "Magnus Pettersson" <magnus@businessvision.se> wrote in message
> news:e4GKHwzuCHA.1960@TK2MSFTNGP11...
> > Hi !
> >
> > We are using application roles in our client.
> >
> > Now we would like to run a remote procedure or call a
> > view with a table in an other database.
> >
> > Is there a workaround without using the guest account,
> > the DBAdmin is not fond of using the guest account, to connect to
another
> > database ?
> >
> > Any suggestion is fine
> >
> > Best regards Magnus
> >
> >
> >
> >
> >
>
>

Relevant Pages

  • Application roles Please Help!
    ... We are using application roles in our client. ... Now we would like to run a remote procedure or call a ... view with a table in an other database. ... Is there a workaround without using the guest account, ...
    (microsoft.public.sqlserver.security)
  • RE: Error 916: Server user X is not a valid user in database X
    ... What service pack are you running on the client machines where the ... Does the User Guest exist in the BBB database? ... | Content-Class: urn:content-classes:message ... | Subject: Error 916: Server user X is not a valid user in database X ...
    (microsoft.public.sqlserver.security)
  • Re: Application roles Please Help!
    ... database, the guest account is required. ... >> create your views as dbo then grant select to the App role. ...
    (microsoft.public.sqlserver.security)
  • Re: Application Role & 2nd Database
    ... receive the error "Server user 'price_9' is not a valid user in database ... EXEC sp_configure 'Cross DB Ownership Chaining', ...
    (microsoft.public.sqlserver.security)
  • Re: Col_Name is not reporting from temp table...
    ... > Returns the database object identification number. ... > When the parameter to a system function is optional, the current database, ... > computer, server user, or database user is assumed. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)