Anyone know how to link up the account and user tables (and all the intermediary tables) to get a list of records accessible by a single user? 

select  sysdba.ACCOUNT.ACCOUNT
FROM sysdba.ACCOUNT
INNER JOIN sysdba.SECRIGHTS ON (sysdba.SECRIGHTS.ACCESSID = 'XXXX' AND sysdba.ACCOUNT.SECCODEID = sysdba.SECRIGHTS.SECCODEID)

I would appreciate if anyone can confirm that the above is correct.    XXXX would be the USERID from the USERINFO table.

Any help would be appreciated.  Thanks.

2 ways:

  There is a view already provided by SLX that has security built into it:

  SELECT * FROM ACCOUNT_ WHERE ACCESSID_ = 'TheUserID'

  Or:

  SELECT * FROM ACCOUNT A

  INNER JOIN SECRIGHTS R ON A.SECCODEID = R.SECCODEID

  WHERE R.ACCESSID = 'TheUserID'