Re: Using domain login names for access control?

Anything in Active Directory you can get -- if you know
where it is and have permission.

using ADO, you can query against active directory,
using SQL or ldap_dialect:

SELECT ADsPath, cn FROM 'LDAP://OU=Sales,
DC=Fabrikam,DC=COM' WHERE
objectCategory='person' AND objectClass ='user'

http://msdn.microsoft.com/library/en-us/adsi/adsi/ldap_dialect.asp


(david)


"DaveK" <DaveK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4FF1B27B-D568-4D14-BCC6-77F5F3812697@xxxxxxxxxxxxxxxx
I would like to make a table containing a list of selected users, their
SIDs
or at least NT domain login names and an admin granted level of security
for
later queries. How do I go about comparing the current user with the list
of
login names? I guess I can live without the SID part, but I do want to
limit
certain users to certain queries based on their NT domain names. Is this
possible? I cannot find any VBA calls to retrieve who is using the DB.
My
system has a front end for forms and reports and is connected to a SQL
backend. It is pretty much all done, the SQL works fine, but now I want
to
limit who sees what. I plan to compare the login ID with their security
level to modify the query so they see only the data for their region.
Thanks
for any pointers.


.

Relevant Pages

  • Re: Stop to modify the SQL query manually entered into query !
    ... Edit button so you just dump the SQL in and be done with it. ... You can go the ODBC route, or the ADO route. ... >>> with Oracle, when using functions in a manual SQL query into Excel, the>> alias for the ciolumns are SYTEMATICALLY ignored or dropped. ...
    (microsoft.public.excel.programming)
  • RE: Can you use VBA to query an Access database without importing
    ... The best way to accomplish that task is through ADO. ... learn a little SQL to query the database. ... Oracle and SQL server. ...
    (microsoft.public.excel.programming)
  • Re: ADO to mdb joins
    ... Do this NOT using a linked (SQL) table, but using an ADO ... >> Currently, I am using an ADO connection to return an ADO recordset, ... > Through query to get SQL data. ...
    (microsoft.public.access.queries)
  • Re: Batch Updates
    ... schema.ini file and this is why this connection is not working with my ... Access table for the insert to part of the sql statement. ... ADO? ... I am currently loading a delimited file into a query and then parsing the ...
    (borland.public.delphi.database.ado)
  • OLE DB Provider
    ... I'm trying to connect to the Active Directory from SQL. ... FROM OPENQUERY(ADSI, ... This query returns the follwing error: ...
    (microsoft.public.sqlserver.programming)
Quantcast