Home » Developer & Programmer » Forms » Table Oriented User Rights (Oracle forms 6i)
Table Oriented User Rights [message #430341] Tue, 10 November 2009 02:46 Go to next message
goharshamke@yahoo.com
Messages: 14
Registered: July 2008
Junior Member
I have build a sw containing 20 forms & 35 reports.
I have created users table.
Now I want to assign different rights to different users like update, view , update, print, delete etc etc...
Enable disable add/delete/update buttons on basis of user rights
Thanks in advance

Regards,
Gohar
Re: Table Oriented Users Rights [message #430349 is a reply to message #430341] Tue, 10 November 2009 03:10 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Quote:
I have build a sw using oracle forms 6i

Then u can also built a maintenance module for rights there are several ways to do it. Suppose you have a Column Authorize as "Y" and "N" whoever has the Flag enable set item property insert update delete allow other wise let them only be an audience for the show. Buttons can be also validated in the same way.

Jak

[Updated on: Tue, 10 November 2009 03:12]

Report message to a moderator

Re: Table Oriented Users Rights [message #430363 is a reply to message #430341] Tue, 10 November 2009 03:34 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why reinventing what Oracle already offers? Don't create "users table" - create database users. Then create roles. Then grant roles to users.
Re: Table Oriented Users Rights [message #430380 is a reply to message #430349] Tue, 10 November 2009 04:42 Go to previous messageGo to next message
goharshamke@yahoo.com
Messages: 14
Registered: July 2008
Junior Member
Thanks for reply.
I think I do need more elaboration with example please. As I could not understand.

Re: Table Oriented Users Rights [message #430386 is a reply to message #430363] Tue, 10 November 2009 04:54 Go to previous messageGo to next message
goharshamke@yahoo.com
Messages: 14
Registered: July 2008
Junior Member
But here I need to block some users to access some forms, while allow others to click and open others users.Similarly some users could not access some reports,some users could make data entry other change it only , third delete it varying from form-to-form base.
I think that can be made possible only through customized security rights.
If some body have implemented such application based rights, Please be kind to send me the fmb module with procedure. As I am stuck absolutely.

Thanks,
Gohar
Re: Table Oriented Users Rights [message #430431 is a reply to message #430386] Tue, 10 November 2009 06:55 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Quote:
send me the fmb module with procedure


Before joining any Software firm you are surely signing a confidential & data securiy agreement. Dont ask for anything readymade. let us know where you stuck.The ppl on this forum will be happy to hekp and support you.


Jak
Re: Table Oriented Users Rights [message #430604 is a reply to message #430431] Wed, 11 November 2009 03:09 Go to previous messageGo to next message
goharshamke@yahoo.com
Messages: 14
Registered: July 2008
Junior Member
I do not know how to do implement below..

I need to block some users to access some forms, while allow some users to click and open data entry forms. Similarly some users could not access some reports,some users could make data entry other change it only , third delete it varying from form-to-form and user to user types.
How to apply such security rights, basis on users table or else approach pl desc in detail



Thanks,
Gohar
Re: Table Oriented Users Rights [message #430608 is a reply to message #430604] Wed, 11 November 2009 03:22 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Smile Well Okay give me your email ID i will send you something you can refer with.


Jak
Re: Table Oriented Users Rights [message #430618 is a reply to message #430608] Wed, 11 November 2009 03:50 Go to previous messageGo to next message
goharshamke@yahoo.com
Messages: 14
Registered: July 2008
Junior Member
Dear JAK,

My email ID is

goharshamke@yahoo.com


Thanks & regards,

Gohar
Re: Table Oriented Users Rights [message #430718 is a reply to message #430618] Thu, 12 November 2009 00:09 Go to previous messageGo to next message
goharshamke@yahoo.com
Messages: 14
Registered: July 2008
Junior Member
Dear JAK,

I will be grateful for your help.
I am waiting a helpful solution from you please

My email ID is

goharshamke@yahoo.com


Thanks & regards,

Gohar
Re: Table Oriented Users Rights [message #431069 is a reply to message #430718] Sat, 14 November 2009 05:11 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Dear Gohar ,


I have send you one form for User Maintenance please let us know if you find it useful. U have to design the table according to your forms and users.

Javed
Re: Table Oriented Users Rights [message #478596 is a reply to message #431069] Mon, 11 October 2010 04:03 Go to previous message
zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan
Junior Member
Dear Javed Khan,

Can u send me the form for User Maintenance as well

my id is zi.zafariqbal@gmail.com

Thanks

Previous Topic: webutil_file_transfer.client_to_db
Next Topic: ORACLE ERROR Unable to read list of values
Goto Forum:
  


Current Time: Thu Sep 19 20:26:15 CDT 2024