Re: New database user / denying access / view / odbc
From: Michael Vardnghus (mivar@wmdata.com)
Date: 08/31/02
- Next message: Michael Vardinghus: "Re: New database user / denying access / view / odbc"
- Previous message: pablo: "Re: logged in user can't see tables"
- In reply to: BP Margolin: "Re: New database user / denying access / view / odbc"
- Next in thread: Michael Vardinghus: "Re: New database user / denying access / view / odbc"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Michael Vardnghus" <mivar@wmdata.com> Date: Sat, 31 Aug 2002 11:58:58 -0700
Thanks for the quick answer
In the odbc data source administrator i chose "with sql
server authentication...." instead of windows nt
authentication.
And I entered then new databaser user in "login id"
However...i am running on a laptop where i have installed
an sql-server and i'm connecting to this through odbc on
the same machine ...could this have any influence ... does
it only work in a true client / server environment ?
Can it be a bug in microsoft query that comes with excel ?
When i select a table in the graphical userinterface i am
allowed to (despite of the fact that i shouldn't be...)
but when i in the same tool choose to select data by
writing an sql-statement i am not allowed...
\Michael V.
>-----Original Message-----
>Michael,
>
>I know this isn't a lot of help, but Query Analyzer
connects to SQL Server
>via ODBC, so I doubt very much whether this is an ODBC
issue.
>
>My best guess, is that your application ODBC connection
string is using
>Windows Authentication, and so is connecting as you, and
your permissions,
>rather than that of the user that you are trying to
impersonate.
>
>-------------------------------------------
>BP Margolin
>Please reply only to the newsgroups.
>When posting, inclusion of SQL (CREATE TABLE ...,
INSERT ..., etc.) which
>can be cut and pasted into Query Analyzer is appreciated.
>
>"Michael Vardinghus" <mivar@wmdata.com> wrote in message
>news:aaec01c2511d$e6fa9b00$35ef2ecf@TKMSFTNGXA11...
>> Hello
>>
>> I have a problem. I have created a new database role to
>> wich I have created a new user - this user has only been
>> granted access to a view that I have created.
>>
>> When I try to select something from query analyzer with
>> the new user it works perfectly - i can select something
>> from the tables that the user has no rights to -
>> however....
>>
>> When I connect through odbc to the database with the new
>> database user i can select from the tables that the user
>> has no rights to ?
>>
>> Why doesn't it work with the odbc connection.
>
>
>.
>
- Next message: Michael Vardinghus: "Re: New database user / denying access / view / odbc"
- Previous message: pablo: "Re: logged in user can't see tables"
- In reply to: BP Margolin: "Re: New database user / denying access / view / odbc"
- Next in thread: Michael Vardinghus: "Re: New database user / denying access / view / odbc"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
