more than one user [message #219550] |
Wed, 14 February 2007 22:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
Hi All.. I have a database schema. There are 10 users to be connected with different privileges.
I have put the entry forms and reports in a folder on each client PC. How can different user be connected to this database with different privileges?
Should I grant select,update..etc on each object to each user or is there any other better option available..
I am using 8i, win2k3, forms6i...
Plz help...
Thanking you,
Rzkhan
|
|
|
|
Re: more than one user [message #219555 is a reply to message #219553] |
Wed, 14 February 2007 23:32 ![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) |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
I have created a role "RESTR" with only select privilges on all objects. But when I connect to main Form with this user there is no data in any form...
although all works fine on SQL. Plz guid.
rzkhan
|
|
|
|
|
|
Re: more than one user [message #219563 is a reply to message #219560] |
Thu, 15 February 2007 00:28 ![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) |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
It shows
SQL Statement in error:
SELECT ROWID,EMPID,TITLE,ENAME FROM EMP
error:
ORA-00942: table or view does not exist
But I wonder it works fine with the original user where objects have been created..
RZkhan
|
|
|
|
Re: more than one user [message #219569 is a reply to message #219563] |
Thu, 15 February 2007 00: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) |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
Please also note
The table exists but is in a different schema from the current.
But I have granted role to this user with select privs on all objects of the target schema.
Help plz
rzkhan
|
|
|
Re: more than one user [message #219573 is a reply to message #219569] |
Thu, 15 February 2007 00:42 ![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) |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
I am using a form for data entry etc.. Where to include schemaname.username in the form... I have just created a database block and created the form run time.
plz guide...
or is there any other solution?
rzkhan
|
|
|
|
Re: more than one user [message #219681 is a reply to message #219569] |
Thu, 15 February 2007 07:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21809 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
rzkhan | But I have granted role to this user with select privs on all objects of the target schema.
|
What happens if you grant privileges DIRECTLY to the user (not through the role you mentioned)?
|
|
|