Forum Stats

  • 3,874,838 Users
  • 2,266,780 Discussions
  • 7,911,975 Comments

Discussions

user access probelm

3276943
3276943 Member Posts: 99 Green Ribbon
edited Aug 15, 2016 10:44PM in General Database Discussions

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

«13

Answers

  • John Thorton
    John Thorton Member Posts: 14,493 Silver Crown
    edited Aug 11, 2016 7:14AM
    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 deportmentplease guide me step by step regadr


    How do I ask a question on the forums?



  • AndrewSayer
    AndrewSayer Member Posts: 13,007 Gold Crown
    edited Aug 11, 2016 7:37AM

    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.

  • jr-phDBA
    jr-phDBA Member Posts: 238 Blue Ribbon
    edited Aug 11, 2016 7:41AM

    Maybe you can just mirror the privilege from existing users.

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    edited Aug 11, 2016 7:51AM
    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 deportmentplease guide me step by step regadr

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

  • IT-HILLS
    IT-HILLS Member Posts: 89 Blue Ribbon
    edited Aug 11, 2016 8:13AM

    Dear Sir,

    Please paste the error details.

    Thanks & Regards.

  • 3276943
    3276943 Member Posts: 99 Green Ribbon
    edited Aug 12, 2016 6:00AM

    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

  • AJ
    AJ Member Posts: 1,358 Silver Trophy
    edited Aug 12, 2016 6:07AM

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

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

    AJ

  • 3276943
    3276943 Member Posts: 99 Green Ribbon
    edited Aug 12, 2016 6:19AM

    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

    errorinform.pngora-09.png

  • AJ
    AJ Member Posts: 1,358 Silver Trophy
    edited Aug 12, 2016 6:25AM

    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;

  • Vlad Visan-Oracle
    Vlad Visan-Oracle Member Posts: 1,249 Bronze Crown
    edited Aug 12, 2016 6:29AM

    What do you get from :

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

This discussion has been closed.