| distribute voucher's edit rights + voucher delete rights + vocucher entering rights in mutiuser envr [message #665541] |
Sat, 09 September 2017 05:11  |
 |
adil shakeel
Messages: 47
Registered: August 2017
|
Member |
|
|
Sir I have oracle 10 g express edd , 6 i forms and reports
I have designed a full fledge FMS (Financial Management System) oracle accounting software for a textile unit.
There are numereous different user of this Software, located at different geographically different locations.
Now want to distribute the rights of every user differently.
For some users I want to give full rights to entry forms
for some only voucher entry rights
for some only entry rights + editing rights but not deletion rights.
Please guide me how can I do this so when any particular user opens this software and enters its own login user and pwd then predefined rights should to conferred to him and so on.....
|
|
|
|
|
|
|
|
| Re: distribute voucher's edit rights + voucher delete rights + vocucher entering rights in mutiuser envr [message #665549 is a reply to message #665547] |
Sun, 10 September 2017 05:49  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
You could (should?) create different roles. For example, RL_NO_DELETE would be used by users which can't delete anything. You'd then grant all privileges you find appropriate (such as SELECT, INSERT, UPDATE) to RL_NO_DELETE (but you, obviously, wouldn't grant DELETE to it):grant select, insert, update to rl_no_delete;
I suppose that users (created by CREATE USER statement) already exist in your database. Therefore, you'd now grant any combination of roles to each of those users. For example:grant rl_no_delete to adil;
You'd do the same for as many roles as you want (for example, you mentioned full rights (such a role would be granted everything), entry + editing privileges (so you'd grant select, update, insert to that role), etc.) and all users that exist in your database.
For much more information, yes - you should read documentation and educate yourself properly.
[Updated on: Sun, 10 September 2017 05:49] Report message to a moderator |
|
|
|
| Re: distribute voucher's edit rights + voucher delete rights + vocucher entering rights in mutiuser envr [message #665551 is a reply to message #665547] |
Sun, 10 September 2017 06:48 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
adil shakeel wrote on Sun, 10 September 2017 03:03Sir whether I have to study the all more than 100 pages to restrict users' rights.
Given what we now know from one of your other threads (http://www.orafaq.com/forum/m/665540/#msg_665540) you have much, much more to study than that. In that thread, on Sat, 09 September 2017 04:01 USCDT, you wrote, "In addition to your knowledge Basically I am a finance student, and do not have the base of I.T."
Now you say " have designed a full fledge FMS (Financial Management System) oracle accounting software for a textile unit. There are numereous different user of this Software,"
Do these "numerous users" know that you are "a finance student, and do not have the base of I.T." Do these "numerous users" know that your/their product is based on an obsolete version (10g) of Oracle?
|
|
|
|
|
|
|
|
| Re: distribute voucher's edit rights + voucher delete rights + vocucher entering rights in mutiuser envr [message #665608 is a reply to message #665603] |
Tue, 12 September 2017 07:10 |
|
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
adil shakeel wrote on Tue, 12 September 2017 05:54sir why I am not receiving any reply.
I can't speak for others, but for myself, I've pretty much decided that you are in so far over your head that it is pretty much pointless.
I know this sounds harsh, but sometimes the truth is harsh. One does not become an oracle dba/consultant/software developer with just a couple of months of self-study. You lack the basic understanding of too many fundamentals, and you are doing your clients a severe disservice (to put it mildly) by presenting yourself as a dba/consultant/developer. Trying to help you across your several threads has been like trying to help someone work on a Formula One race car when they don't even understand the principles of the internal combustion engine, or what a socket wrench is, or even how to look something up in the shop manual.
This is not to say you cannot achieve your goal. But you first need to understand that you need to get some formal education in a formal training program, and leverage that to get a job where you can work with and learn from colleagues and mentors in the next cubicle. You did not start your career in finance with just a few months of self-study, and working in IT is far, far more complex.
In my own case, I made such a career change. My college degree is in music. But a couple of years out of college I needed a job and stumbled into a situation where a government agency was filling needed IT positions (programmer/systems analyst) by offering an in-house training and apprenticeship program. Three months of intensive, instructor-lead classroom work, then a year of working directly under a mentor with less formal assistance from other senior techs. And at the end of that period I had just begun to scratch the surface.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
