Forum Stats

  • 3,873,336 Users
  • 2,266,535 Discussions
  • 7,911,512 Comments

Discussions

user access probelm

13»

Answers

  • JohnWatson2
    JohnWatson2 Member Posts: 4,512 Silver Crown
    edited Aug 15, 2016 2:59AM

    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.

  • AndrewSayer
    AndrewSayer Member Posts: 13,007 Gold Crown
    edited Aug 15, 2016 2:59AM
    3276943 wrote:thank you sir your your helpsir i do as per your instructioncreate 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 dataplease 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!

  • andrewmy
    andrewmy Member Posts: 676 Silver Badge
    edited Aug 15, 2016 3:01AM

    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.

  • 3276943
    3276943 Member Posts: 99 Green Ribbon
    edited Aug 15, 2016 3:04AM
  • 3276943
    3276943 Member Posts: 99 Green Ribbon
    edited Aug 15, 2016 3:07AM

    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

  • 3276943
    3276943 Member Posts: 99 Green Ribbon
    edited Aug 15, 2016 3:10AM

    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

  • 3276943
    3276943 Member Posts: 99 Green Ribbon
    edited Aug 15, 2016 4:01AM

    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 REGARDpic2.pngpic1.png

  • andrewmy
    andrewmy Member Posts: 676 Silver Badge
    edited Aug 15, 2016 4:22AM

    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

  • 3276943
    3276943 Member Posts: 99 Green Ribbon
    edited Aug 15, 2016 5:56AM

    yes sir

    you are right role is better as compare to schema name

  • andrewmy
    andrewmy Member Posts: 676 Silver Badge
    edited Aug 15, 2016 10:44PM

    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.

This discussion has been closed.