Home » RDBMS Server » Server Administration » user access problem
user access problem [message #654719] Thu, 11 August 2016 04:58 Go to next message
mfahimaamirgmailcom
Messages: 62
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
Re: user access problem [message #654724 is a reply to message #654719] Thu, 11 August 2016 06:03 Go to previous messageGo to next message
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

Re: user access problem [message #654727 is a reply to message #654719] Thu, 11 August 2016 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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."
Re: user access problem [message #654734 is a reply to message #654719] Thu, 11 August 2016 06:52 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Same question you asked here: https://community.oracle.com/thread/3960648
Re: user access problem [message #654739 is a reply to message #654734] Thu, 11 August 2016 07:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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".
Re: user access problem [message #654765 is a reply to message #654739] Fri, 12 August 2016 01:18 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
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
Re: user access problem [message #654768 is a reply to message #654765] Fri, 12 August 2016 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.
Re: user access problem [message #654770 is a reply to message #654765] Fri, 12 August 2016 02:34 Go to previous messageGo to next message
John Watson
Messages: 8922
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:
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 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
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
Re: user access problem [message #654821 is a reply to message #654820] Mon, 15 August 2016 01:58 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
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
Re: user access problem [message #654823 is a reply to message #654822] Mon, 15 August 2016 02:21 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: user access problem [message #654824 is a reply to message #654823] Mon, 15 August 2016 02:45 Go to previous message
mfahimaamirgmailcom
Messages: 62
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
Previous Topic: how connect with 12c
Next Topic: how can open database when database already shutdown
Goto Forum:
  


Current Time: Thu Mar 28 10:46:53 CDT 2024