| User Authentication [message #553760] |
Tue, 08 May 2012 06:50  |
shahzad-ul-hasan
Messages: 617
Registered: August 2002
|
Senior Member |
|
|
Dear
I have made an application in forms 6i. Now i want if user can update, or modify the data it will required autometic authenication. Administrator will gives his password then the updation will continue otherwise rollback the transaction.pls advised how it is possible.
|
|
|
|
| Re: User Authentication [message #553840 is a reply to message #553760] |
Tue, 08 May 2012 14:52  |
 |
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Why wouldn't you let Oracle handle that?
- "Owner" owns a schema. Nobody connects as the "owner" in order to work with the application
- Create some predefined roles. For example, a role named "regular_user" will be able to do anything (insert new records, update existing ones, delete records). "View_only" will be able to query records - no updates or inserts or deletes. Etc.
- Grant privileges on "owner's" objects to these roles, such as
grant all on table_one to regular_user;
grant select, update on table_two to regular_user;
...
grant select on table_one to view_only;
grant select on table_two to view_only;
...
- You create new Oracle users, for every person who will work with the application.
- Grant roles to these users. For example:
create user littlefoot identified by lf ...;
grant view_only to littlefoot;
create user shahzad identified by ...;
grant regular_user to shahzad;
...
Doing so, administrator won't have to do anything but enjoy, because Oracle will handle everything. Why would anyone (administrator in your case) have to wait until someone calls, provide some "password" and let people work? That's - from my point of view - not the right way to do the job.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
