Results 1 to 3 of 3

Thread: Access to the system user

  1. #1
    Senior Member
    Join Date
    Oct 2019
    Posts
    156

    Access to the system user

    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

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,718
    Blog Entries
    17
    ? sqlEval([select username from system!sysroles where username="admin"])

    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,712
    Hi Olaf,

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

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

    Yvonne

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us