Hiya
To date I've created several apps with small numbers of users. In the system I have used, each user has a separate user account in Oracle 8.1.5 and the username is fed through to access to different levels of data using the USER. I've used raw webdb reports and forms, and PL/SQL scripts to provide the customers with what they need (no, they really are customers, I'm not just trying to say users...).
I'm now trying to work out the best way to provide a web site access that doesn't require a dialogue password - for example so that anyone can go to a web page and insert answers to a questionnaire and I can create the back end to insert the data into a table. Or, so that the user can log in using the web page using text fields rather than a dialogue, and I can keep the usernames and passwords in a table rather than having the users in a user account and then matching this up with the user tables. The number of users for the new app is much higher than previously so I need to find out a way of managing all this without using the user accounts.
Has anyone any advice or suggestions as to where to find out more about this? Is the Webdb create sites one to explore (I have tried this but despite having the requisite grant options, can't get it working! I'll try the webdb forum for answers on this.)
Sorry if this is Doh! level, but I've spent all my time using the user accounts so have never got into this.
Regs, Sid
To date I've created several apps with small numbers of users. In the system I have used, each user has a separate user account in Oracle 8.1.5 and the username is fed through to access to different levels of data using the USER. I've used raw webdb reports and forms, and PL/SQL scripts to provide the customers with what they need (no, they really are customers, I'm not just trying to say users...).
I'm now trying to work out the best way to provide a web site access that doesn't require a dialogue password - for example so that anyone can go to a web page and insert answers to a questionnaire and I can create the back end to insert the data into a table. Or, so that the user can log in using the web page using text fields rather than a dialogue, and I can keep the usernames and passwords in a table rather than having the users in a user account and then matching this up with the user tables. The number of users for the new app is much higher than previously so I need to find out a way of managing all this without using the user accounts.
Has anyone any advice or suggestions as to where to find out more about this? Is the Webdb create sites one to explore (I have tried this but despite having the requisite grant options, can't get it working! I'll try the webdb forum for answers on this.)
Sorry if this is Doh! level, but I've spent all my time using the user accounts so have never got into this.
Regs, Sid