user access problem [message #654719] |
Thu, 11 August 2016 04:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/cf5d7c9cc796885aaa693d1815aa858c?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
Re: user access problem [message #654739 is a reply to message #654734] |
Thu, 11 August 2016 07:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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 #654770 is a reply to message #654765] |
Fri, 12 August 2016 02:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #654823 is a reply to message #654822] |
Mon, 15 August 2016 02:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/cf5d7c9cc796885aaa693d1815aa858c?s=64&d=mm&r=g) |
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
|
|
|