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

From: BP Margolin (bpmargo@attglobal.net)
Date: 08/31/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Sat, 31 Aug 2002 14:49:18 -0400

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: Unable connect to sybase database
    ... Turn it off if you are on a corporate network. ... Recreate the odbc connection and see if it works. ... Or else you can go for OLE DB Providers to connect to the database. ... OLE DB is an advanced protocol and much better than ODBC. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Issues with linking encrypted tables
    ... >> If it is Paradox, how can I tell what version of Paradox? ... don't give out the password to the actual database: ... I expect it's making an ODBC connection ... 2002 frontend without any ODBC connection. ...
    (comp.databases.paradox)
  • RE: ODBC--Connection to Database failed
    ... Have you defined on your ODBC connection the database you working with? ... > this .mdb file, and runs a query, and it works for him. ...
    (microsoft.public.access.gettingstarted)
  • Re: CRecordset::Open and MySQL (ODBC) - nOpenType ?
    ... I started a new application through the steps of the assistant with ODBC ... This means the DSN would be shown but not accepted. ... Now I think that my version of VS2005 isn't able to access a MySQL database ... the ODBC connection that is forcing the forward-only. ...
    (microsoft.public.vc.database)
  • 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)