Access to the system user

[Schlingmeier]

s it possible that I can access the user table to check whether a certain user has been created. With the function username () I get the registered user. I would like to know a function where I can check whether this user is also contained in this system user table.
Thanks for the support.
greeting
Olaf

[barrymavin]

? sqlEval([select username from system!sysroles where username="admin"])

[yvonne.milne]

Hi Olaf,

The table is 'sysroles' in the 'system' database. It has an index tag 'username' on the username field. So, e.g.

? keylookup("system!sysroles","username","NameToSearch",.T.,.F.)

Regards,

Yvonne