Re: New database user / denying access / view / odbc

From: Michael Vardinghus (mivar@wmdata.com)
Date: 08/31/02 

From: "Michael Vardinghus" <mivar@wmdata.com>
Date: Sat, 31 Aug 2002 12:49:56 -0700

I think that was it...I didn't have a proper client /
server environment. I logged of my normal use and logged
on as guest - when I used the same odbc-connection with
the same database user I was restricted the way I should
be.

I didn't make any changes but now I'm pretty sure that it
will work in a real environment.

>-----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.
>
>
>.
>

Relevant Pages

  • Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... credential to be used if those are for a SQL account. ... > The problem I have now is in modifying the ODBC connection. ... >> Starting Win2000, the machine accounts are security principals, ...
    (microsoft.public.win32.programmer.wmi)
  • Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... credential to be used if those are for a SQL account. ... > The problem I have now is in modifying the ODBC connection. ... >> Starting Win2000, the machine accounts are security principals, ...
    (microsoft.public.windows.server.security)
  • RE: Can VBA Plug in ODBC password?
    ... Dim dbODBC As Database, strConnect As String, strSQL As String ... I have the ODBC connection working, but it requires that a password is ... Is there a way in VBA to make the ODBC connection and plug in the password ...
    (microsoft.public.access.externaldata)
  • RE: Can VBA Plug in ODBC password?
    ... Dim dbODBC As Database, strConnect As String, strSQL As String ... I have the ODBC connection working, but it requires that a password is ... Is there a way in VBA to make the ODBC connection and plug in the password ...
    (microsoft.public.access.externaldata)
  • Re: Office 2007 & ODBC
    ... The data source is w/in sage. ... If I pull the data into either Excel or Access, ... experiment with, and when I attempted an ODBC connection with Excel, ...
    (microsoft.public.word.mailmerge.fields)