Java Development Tools

3276943 wrote:
sir 
i use oracle 12c with form 6i in server without any problem 
how i give to client with other user 
i try to create new user and give DBA right for client feeding 
but user can not feeding 
when i access by server or main user/password then user access form without any problem and feed data easily 
please guide me how i create user and how give privilege to user for feed 
because we need near 20 user for feed in different deportment
please guide me step by step 
regadr

How do I ask a question on the forums?

You've opened 15 threads and have only marked one as answered. Do you think that fairly reflects reality?

What error are you seeing?

What does feed data mean? Is it a forms thing?- then ask in the forms space (I'm sure you're as sick of hearing this as we are of telling you)

You normally do not require granting DBA privilege to a user to perform simple data loads.

Maybe you can just mirror the privilege from existing users.

3276943 wrote:
sir 
i use oracle 12c with form 6i in server without any problem 
how i give to client with other user 
i try to create new user and give DBA right for client feeding 
but user can not feeding 
when i access by server or main user/password then user access form without any problem and feed data easily 
please guide me how i create user and how give privilege to user for feed 
because we need near 20 user for feed in different deportment
please guide me step by step 
regadr

Same question you asked here: OraFAQ Forum: Server Administration » user access problem

Dear Sir,

Please paste the error details.

Thanks & Regards.

GRANT CONNECT TO abc

GRANT CONNECT, RESOURCE, DBA TO abc

GRANT CREATE SESSION to abc

GRANT ANY PRIVILEGE TO abc

GRANT

  SELECT,  INSERT,  UPDATE,  DELETE ON  MDADESIGNATION TO  abc;

sir i try to  give data feeding right to new user

see my step

1.create user abc identified by abc;

2. grant dba to abc;

3.grant all privileges to abc;

4.grant create session to abc;

5.GRANT CONNECT TO abc

6.GRANT CONNECT, RESOURCE, DBA TO abc

7.GRANT ANY PRIVILEGE TO abc

8.GRANT   SELECT,  INSERT,  UPDATE,  DELETE ON  MDADESIGNATION TO  abc;

after this i open form 6i and connect with user abc

that connect but when i try to get data and press F8 for retrieve data then form give me error FRM 40505

also when i try to give sysda right to abc use the SQLplus give me error insufficient privileges

see full please give me idear how i give right to user for feeding

also i pres Shift+F1 then form open error window and show error

ORA-00942: table or view does not exist

dear please help me regrd

You need to post the entire output of the commands you're running.

Also, I recommend that you google "oracle least privilege principle".

AJ

sir see both error

when i press F8 then error is FRM-40505

and when press shft+f1 same time then show me the problem and show error ora-0092

see both picture

What I meant was:

Post the entire output of these commands:

1.create user abc identified by abc;

2. grant dba to abc;

3.grant all privileges to abc;

4.grant create session to abc;

5.GRANT CONNECT TO abc

6.GRANT CONNECT, RESOURCE, DBA TO abc

7.GRANT ANY PRIVILEGE TO abc

8.GRANT   SELECT,  INSERT,  UPDATE,  DELETE ON  MDADESIGNATION TO  abc;

What do you get from :

select owner,object_name,object_type from dba_objects where object_name='MDADESIGNATION';

Either

a) The privileges have not been granted correctly (verify by checking if the user has SELECT privilege in dba_tab_privs where table_name = <whatever table that has the error>)

b) The tables need to be referenced with owner prefix e.g. <owner>.<table_name>

To get around (b), you could create public synonyms referring to <owner>.<table_name>

I would recommend that instead of granting the privileges to each user directly, that you grant them to a created role instead. That way if you need to adjust them in the future, you just to it once.

create role xxxrole;

grant select on <owner>.<table_name> to xxxrole;

...

...

create user user1;

grant xxxrole to user1;

Dear Sir,

Please provide the below query output.

select owner,table_name from dba_tables.

please log on as abc in

and give the below select statement

select * from owner.MDADESIGNATION--here owner is output from the 1st select statement.

Thanks & Regards.

SHANTHI SOCIAL SERVICES COIMBATORE skrev:
Dear Sir,
Please provide the below query output.
select owner,table_name from dba_tables.

please add a where predicate here else we will have a potential output of thousands of tables.

AJ

Dear Sir,

Please provide the below query output.

select owner,table_name from dba_tables WHERE TABLE_NAME = 'MDADESIGNATION'

please log on as abc in

and give the below select statement

select * from owner.MDADESIGNATION--here owner is output from the 1st select statement.

Thanks & Regards.

Do you really need to grant dba and sysdba in order to run your data feed? Still I have no idea what data feed means.

Dba and sysdba, and for that matter most of those grants are like handing your DB over to a user and saying "have fun"

You should be following the security practise of least privilege - only grant what is necessary to do the job. If a job requires such powerful grants I'd question if it should be run using forms.

https://docs.oracle.com/database/121/CNCPT/cmntopc.htm#CNCPT123

It appears that you don't know how Oracle security works.

3276943 wrote:
GRANT CONNECT TO abc
GRANT CONNECT, RESOURCE, DBA TO abc
GRANT CREATE SESSION to abc
GRANT ANY PRIVILEGE TO abc
GRANT
 SELECT, INSERT, UPDATE, DELETE ON MDADESIGNATION TO abc;
sir i try to give data feeding right to new user
see my step
1.create user abc identified by abc;
2. grant dba to abc;
3.grant all privileges to abc;
4.grant create session to abc;
5.GRANT CONNECT TO abc
6.GRANT CONNECT, RESOURCE, DBA TO abc
7.GRANT ANY PRIVILEGE TO abc
8.GRANT SELECT, INSERT, UPDATE, DELETE ON MDADESIGNATION TO abc;
 after this i open form 6i and connect with user abc
that connect but when i try to get data and press F8 for retrieve data then form give me error FRM 40505
also when i try to give sysda right to abc use the SQLplus give me error insufficient privileges
see full please give me idear how i give right to user for feeding
also i pres Shift+F1 then form open error window and show error 
ORA-00942: table or view does not exist
dear please help me regrd

Check the role and sys privs of existing users.

select * from dba_role_privs where grantee = '<model_user>';
select * from dba_sys_privs where grantee = '<model_user>';

Then grant the role and sys privs to new users.

Don't grant DBA and other powerful role/sys privs

thank you for your reply and help

sir this is output of your query

select owner,object_name,object_type from dba_objects where object_name='MDADESIGNATION';

OWNER       OBJECT_NAME       OBJECT_TYPE          

------------------------------------------

MDAMFA     MDADESIGNATION       TABLE                  

thank you sir your your help

sir i do as per your instruction

create role xxxrole;

grant select on MDAMFA.MDADESIGNATION to xxxrole;

grant xxxrole to abc;

but no success form give me same error when i press F8 no show data

please give me next instruction

sir thank you for your help

when i run your query in sql developer then that give me error

select * from owner.MDADESIGNATION

Error starting at line 4 in command:

select * from owner.MDADESIGNATION

Error at Command Line:4 Column:21

Error report:

SQL Error: ORA-00942: table or view does not exist

00942. 00000 -  "table or view does not exist"

please give me next instruction

I've answered your question here,

OraFAQ Forum: Server Administration » user access problem

it is rather confusing when you create topic in two places and give different information in each.

3276943 wrote:
thank you sir your your help
sir i do as per your instruction
create role xxxrole;
grant select on MDAMFA.MDADESIGNATION to xxxrole;
grant xxxrole to abc;
but no success form give me same error when i press F8 no show data
please give me next instruction 

What SQL attempts to execute when you press F8? What is the expected result of executing that SQL? What is the actual result?

If this is a permissions problem then an error would be raised, are you seeing an error? What is the EXACT error message?

If you are not seeing an error then are you supressing them?

If you see no error and no errors are supressed then the problem is not privileges.

You show lack of understanding of basic SQL and yet you are granting sysdba to users, this is a dangerous mix!

Your form did not refer to the table in the form  MDAMFA.MDADESIGNATION 

What do you get when you login as abc and run:

select * from MDAMFA.MDADESIGNATION 

BTW You really need to read the chapter on users in the concepts manual before you start using any of the advice above.

sorry sir

yes sir

select * from MDAMFA.MDADESIGNATION

when i use this query then no error

is right and without error

but sir without this i can not use in form

please guide me i give this schema name in every form

and reports

ragard

sorry to all master my problem solve

sorry i will not post duplicate question again

sorry for my mistake

thank you for your cooperation and help

sir i want to my solution with other user who have same problem in form FRM-40505

sir change only in form, i add the schema name with table name

step

1. datablock

2. table change with schema name

my datablock name is MDADESIGNATION

my table name is MDADESIGNATION

i change only table name with schema name in table propriety query data source name mdamfa.MDADESIGNATION

query data source name = MDAMFA.MDADESIGNATION

THANK YOU REGARD

This solution should work for all users in the same database as long as your form refers to the table by MDAMFA.MDADESIGNATION

What makes you think other users will face problem? Every user created in the same database that is granted SELECT privilege to MDAMFA.MDADESIGNATION either directly or via a role should be able to see the table

yes sir

you are right role is better as compare to schema name

If you do not wish to change all references in your forms from "MDADESIGNATION" to "MDAMFA.MDADESIGNATION", the other alternative you have is to create a public synonym for that table so that any reference from any user (with SELECT privileges) in the same database will be referred to this table.

e.g.

CREATE PUBLIC SYNONYM MDADESIGNATION FOR MDAMFA.MDADESIGNATION;

After this, any user with SELECT on MDAMFA.MDADESIGNATION will be able to refer to this table by the name "MDADESIGNATION" even newly created users.