With no application changes, no additional users but wanting
users to have different access rights depending on what
client is used, I don't think it's possible in a way that
would be supported.
-Sue
On Fri, 29 Jul 2005 00:50:50 +0200, "marta"
[quoted text, click to view] <marta20wawa@go2.pl> wrote:
>Hi
>
>I have users in domain group who use application which uses sqlserve, they
>have rights to insert, update, delete. I want some of the members of this
>domain group to connect directly to the database using query analyzer but
>with right only to read and they still of course can use application and
>have full rights.
>
>I can't change application, i don't want to crate another users with
>different rights.
>
>I want the same user to have different rights using application and query
>analyzer.
>Is it possible ? Maybe something similar
>
>regards
>m.
>
>
Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar
regards
m.
How is the application connecting to the database, WIndows Authentication or
SQL Authentication?
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
[quoted text, click to view] "marta" <marta20wawa@go2.pl> wrote in message
news:dcbngj$2gc$1@atlantis.news.tpi.pl...
> Hi
>
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
>
> I can't change application, i don't want to crate another users with
> different rights.
>
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar
>
> regards
> m.
>
>
>
