Home » RDBMS Server » Security » more than one user
more than one user [message #219550] Wed, 14 February 2007 22:51 Go to next message
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 #219553 is a reply to message #219550] Wed, 14 February 2007 23:09 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,

SCHEMA = USER


for better solution you should create ROLE with require privs and grant to each users/schemas.

regards
Taj
Re: more than one user [message #219555 is a reply to message #219553] Wed, 14 February 2007 23:32 Go to previous messageGo to next message
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 #219556 is a reply to message #219555] Wed, 14 February 2007 23:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
What result your got.>>no rows selected<< or something else.



regards
Taj
Re: more than one user [message #219557 is a reply to message #219556] Thu, 15 February 2007 00:08 Go to previous messageGo to next message
rzkhan
Messages: 370
Registered: March 2005
Senior Member
i get the message

FRM-40505: ORACLE error: unable to perform query

Re: more than one user [message #219560 is a reply to message #219557] Thu, 15 February 2007 00:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Go to "Help - Show error" menu and read what it says; there might be an undefined column (i.e. different column names in a table and in a form) or ... who knows?
Re: more than one user [message #219563 is a reply to message #219560] Thu, 15 February 2007 00:28 Go to previous messageGo to next message
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 #219566 is a reply to message #219563] Thu, 15 February 2007 00:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
SQL Statement in error:
SELECT ROWID,EMPID,TITLE,ENAME FROM EMP

error:


that is expected behaviour.

because you have only select privs on ANOTHER USER TABLES.
and above you SQL statement search EMP table in current user schema instead of OWNER OF TABLE user schema.

you must use schema name before table name specification. SCHEMA.TABLE_NAME.


regards
Taj
Re: more than one user [message #219569 is a reply to message #219563] Thu, 15 February 2007 00:34 Go to previous messageGo to next message
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 messageGo to next message
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 #219575 is a reply to message #219573] Thu, 15 February 2007 00:43 Go to previous messageGo to next message
rzkhan
Messages: 370
Registered: March 2005
Senior Member
schemaname.username


schemaname.tablename
Re: more than one user [message #219681 is a reply to message #219569] Thu, 15 February 2007 07:36 Go to previous message
Littlefoot
Messages: 21806
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)?
Previous Topic: Security Breach using DBSNMP user.
Next Topic: PASSWORD_REUSE_TIME versus PASSWORD_REUSE_MAX
Goto Forum:
  


Current Time: Thu Mar 28 04:47:14 CDT 2024