Query a user's granted access

[Jeff Grant]

Oracle 9i database..
I am wondering what I would type for a query to see if a user was already granted access to specific tablespace. Anyone?

[SJ Adnams]

tablespace is tricky. Are you sure you dont mean 'schema'?
There is a bug in 9iR1 which means you can do an ansi join to any table in any schema
It's been fixed for R2. Ok back to the question. A table can have grants to another user, or role, and a user can have roles. And a role can be given other roles.
If you have OEM installed have a poke around under 'Security'. Sorry I have no idea what an SQL query would look like, far to many combinations to cover.

[SJ Adnams]

ask on dbasupport.com maybe

[Jeff Grant]

Figured out what I wanted to know... I'm not a HUGE Oracle guy, but I know enough to get me in trouble.
What I was looking for was a list of whatever was granted access to the particular user which was signed in. I got the solution by doing a

select * from user_role_privs

Thanks though!
Anyone know how you can set the timeout of a session in JSP with Oracle 9i v9.1? It only won't accept session.setMaxInactiveInterval(900);