-
Forms 9i Authentification
Hi,
I'm trying to create a form in 9i where any user can access the form and retrieve data from the tables.
The problem i'm having is that when the users (expect for the owner of the tables) log on to the form, no data is retrieved when a query is executed.
I've granted various privileges to the other users but they still can't retrieve any data.
Is it possible to create a trigger or code into the form which tables to look for, i.e. 'username.tablename', or will I have to created some kind of public synonym.
Any suggestions will greatly appreciated.
Nick
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|