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 11:40:39 -0700

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: Error code = 4060
    ... divisional portals are running under a different app pool and identity than ... the corporate portal, and the identity of this pool, while having dbo rights ... portal's content database. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Complete Neophyte Question(s)
    ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ... GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ...
    (microsoft.public.sqlserver.security)
  • Re: SUUNTO Vyper PC i/f
    ... username and password. ... to enter the database password. ... I gained access to the data in Suunto v2 using it - but it will NOT allow ... have the rights to the program the DATA is MINE!! ...
    (uk.rec.scuba)
  • Re: "unable to lock database"
    ... rights to create the .ldb ... > file in the same folder as the .mdb. ... > I have some VB which opens a database file. ... > works if I am actually logged on as administrator. ...
    (microsoft.public.vb.database)