| Grouping Users [message #62175] |
Thu, 01 July 2004 23:40  |
Jason Brewster
Messages: 8
Registered: June 2004
|
Junior Member |
|
|
I'm developing a web front end that accesses data from 9ias. I'd like oracle to handle the security of accessing that database, and so each will have a user profile in oracle, rather than all using a generic user profile.
What I'd like to do is have all of the users using a default schema so that is don't have to prefix each tablename with the schema name in my SQL statements.
Is this possible? I'm using enterprise manager console to administer the database but I can't seea likely option to allow me to change a users default schema.
Thanks
Jason
|
|
|
|
|
|
| Re: Grouping Users [message #62179 is a reply to message #62177] |
Fri, 02 July 2004 02:51  |
Jason Brewster
Messages: 8
Registered: June 2004
|
Junior Member |
|
|
Thanks for your reply.
I found another solution to my problem, by creating a synonym for my table.
I assume that with you suggestion I'd have run the sql "alter session set current_schema=your_schema_name;" evertime a user logged on.
If I do it with synonyms I will only have to do each table once.
Thanks
Jason
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
