Getting User Login/Role

[steel]

Hi,

I am wanting to stop a User from opening a Form where the security is based
on their Application Role in SQL.

To get their NT name I use:
txtNT_Name = Dlookup("system_user","sysobjects")

How do I get the Users Application-level role? Is there a better way to go
about this?

I appreciate your help as always.

 

[Sylvain Lafontaine]

Big problem: Application roles and ADP are like oil and water: they don't
mix very well and trying to use application roles inside ADP has proven in
the past to be a death end.

See Google for some past discussions about this:

http://groups.google.ca/group/micro...ation+role&qt_g=1&searchnow=Search+this+group

 

[steel]

Thanks Sylvain,

I had a good read of the Group postings. Very interesting.

Is it possible to get just the Application Role name the User is associated
to by doing a DLookup, similar to the way I was able to get their Login name
(ie domain\username)

This is so I can simply place their Application Role group on an Intro form.

Thanks.
--
Regards,

Alan

Big problem: Application roles and ADP are like oil and water: they don't
mix very well and trying to use application roles inside ADP has proven in
the past to be a death end.

See Google for some past discussions about this:

http://groups.google.ca/group/micro...ation+role&qt_g=1&searchnow=Search+this+group

 

[Sylvain Lafontaine]

I don't know because I don't use Application role.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Thanks Sylvain,

I had a good read of the Group postings. Very interesting.

Is it possible to get just the Application Role name the User is
associated
to by doing a DLookup, similar to the way I was able to get their Login
name
(ie domain\username)

This is so I can simply place their Application Role group on an Intro
form.

Thanks.