OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » user access problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user access problem [message #654719]

Thu, 11 August 2016 04:58

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

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

Report message to a moderator

Re: user access problem [message #654724 is a reply to message #654719]

Thu, 11 August 2016 06:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: user access problem [message #654727 is a reply to message #654719]

Thu, 11 August 2016 06:21

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

give DBA right for client feeding but user can not feeding

Wait he's hungry and explain him how to eat step by step.

[Updated on: Thu, 11 August 2016 06:21]

Report message to a moderator

Re: user access problem [message #654730 is a reply to message #654719]

Thu, 11 August 2016 06:29

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

First off, you should NOT be granting DBA to every user. Why are you doing that?

You need to step back and try again to explain exactly what your problem is. No one is looking over your shoulder. No one can see what you are doing or what is resulting from your actions. And no one knows what you mean by "client feeding."

Report message to a moderator

Re: user access problem [message #654734 is a reply to message #654719]

Thu, 11 August 2016 06:52

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Same question you asked here: https://community.oracle.com/thread/3960648

Report message to a moderator

Re: user access problem [message #654739 is a reply to message #654734]

Thu, 11 August 2016 07:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that you have a schema ("owner") which contains some tables, views, whatever and then you built an application (using Forms 6i) upon that schema.

Now you'd want another (new) users to be able to work with those tables, just like their "owner". It isn't enough to create those users - you'll have to grant certain PRIVILEGES. Some of those privileges (like CREATE SESSION) are granted by a privileged user (such as SYS), while some others (like SELECT, INSERT, UPDATE, DELETE on SOME_TABLE, or EXECUTE on SOME_PROCEDURE) are granted by the "owner".

Report message to a moderator

Re: user access problem [message #654765 is a reply to message #654739]

Fri, 12 August 2016 01:18

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

yes my dear friend exactly right i am schema owner and want to give data feeding right to other user in form 6i (account,inventory and sales user )
sir please you give me sample how down this task
like as
step by step

CREATE USER xyz IDENTIFIED BY abc ;

-- ROLES

-- SYSTEM PRIVILEGES

-- QUOTAS

CREATE SESSION

please help me in this task
regard

Report message to a moderator

Re: user access problem [message #654768 is a reply to message #654765]

Fri, 12 August 2016 01:32

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 01 August 2016 14:58

Michel Cadot wrote on Mon, 01 August 2016 13:05
Michel Cadot wrote on Mon, 01 August 2016 10:38
...
And at least feedback if not thank people who take time to help you.
Review your previous topics and do it now.

Report message to a moderator

Re: user access problem [message #654770 is a reply to message #654765]

Fri, 12 August 2016 02:34

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Quote:

you give me sample how down this task
like as
step by step

Ok, do this:

Code: [Select all] [Show/ hide]

create user abc identified by abc;
grant dba to abc;
grant all privileges to abc;
grant sysdba to abc;

Your user ABC now has permission to do anything in the database, including "feeding". It would be irresponsible not to mention that giving a user privileges like this is not recommended for a production system. However, I would think from this question and others that you are not operating in a legally licensed environment, so (I hope) it is not being used for production purposes.

[Updated on: Fri, 12 August 2016 02:34]

Report message to a moderator

Re: user access problem [message #654820 is a reply to message #654770]

Mon, 15 August 2016 01:36

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

sir i used all below command

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;

sir i connect and login in form but when i press F8 the form give me same error FRM-40505
please give me next instruction
thank you for your help

Report message to a moderator

Re: user access problem [message #654821 is a reply to message #654820]

Mon, 15 August 2016 01:58

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

In your OTN topic here
https://community.oracle.com/message/13978481?tstart=0#13978481
you provided more information: that you are receiving ora-00942 errors.
The reason for this is that your code is not prefixing the table name with the schema name. If you do not do that, you will have to either create public synonyms for the tables or alter your session to set the current schema correctly.

[Updated on: Mon, 15 August 2016 02:00]

Report message to a moderator

Re: user access problem [message #654822 is a reply to message #654820]

Mon, 15 August 2016 02:19

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

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

Report message to a moderator

Re: user access problem [message #654823 is a reply to message #654822]

Mon, 15 August 2016 02:21

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

So what was the solution? You should provide the details, in order to help others who may have the same probelem.
Participating n forums is about giving as well as taking.

Report message to a moderator

Re: user access problem [message #654824 is a reply to message #654823]

Mon, 15 August 2016 02:45

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

ofcourse sir this is my pleasure

sir only in form i change 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

Report message to a moderator

Previous Topic:	how connect with 12c
Next Topic:	how can open database when database already shutdown

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 06:21:09 CDT 2025