Results 1 to 2 of 2

Thread: Read-only role

  1. #1
    Join Date
    Mar 2008
    Posts
    3

    Unanswered: Read-only role

    Hi All,

    Could you please let me know how do i identify which role has the read-only access. Basically, i need to provide read-only access to the users in the database, for which i need to identify the read only role in the informix database..

    Thanks in advance..

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    There is no easy way to do this...
    You need check all grants from the role.
    Code:
    select * from systabauth order by grantee
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •