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:01:34 -0700

There was an critical error in my first description. It
should have said "When I try to select something from
query analyzer with the new user it works perfectly - i
CANT'T select something"

So I am restricted in query analyzer the way I should be.

>-----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: Does JET process (slowly) the qdf.OpenRecordset statement?
    ... Have you run the SP in the Query Analyzer. ... read the following articles to exclude some known issues and apply the suggestions within the following KB ... How to Optimize Microsoft Access When Using ODBC Data Sources ... Queries Are Slower After You Install Microsoft Jet 4.0 Service ...
    (microsoft.public.access.formscoding)
  • Re: SQLServerAgent will not start - "Event ID: 103" - URGENT HELP
    ... You can get ODBC errors using Query Analyzer - Query ... Analyzer connects to SQL Server using ODBC. ... Have you tried running client network utility and SQL server ...
    (microsoft.public.sqlserver.odbc)
  • Re: Special characters on passwords
    ... Query Analyzer uses ODBC for its connections. ... I would suspect that the embedded semicolon is wreaking havoc with the ... internally-generated Connection String. ... It's a pain in the arse, but I tried it and it worked with Query Analyzer ...
    (microsoft.public.sqlserver.server)
  • Re: New database user / denying access / view / odbc
    ... 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. ... is that your application ODBC connection string is using ... I have created a new database role to ...
    (microsoft.public.sqlserver.security)
  • Re: Using openrowset to select foxpro table data through odbc ?
    ... > What is the syntax to use openrowset to select visual foxpro table data ... > through odbc in query analyzer? ...
    (microsoft.public.sqlserver.programming)