OraFAQ Forum: Security » more than one user

Home » RDBMS Server » Security » more than one user

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

more than one user [message #219550]

Wed, 14 February 2007 22:51

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

Report message to a moderator

Re: more than one user [message #219553 is a reply to message #219550]

Wed, 14 February 2007 23:09

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

Report message to a moderator

Re: more than one user [message #219555 is a reply to message #219553]

Wed, 14 February 2007 23:32

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

Report message to a moderator

Re: more than one user [message #219556 is a reply to message #219555]

Wed, 14 February 2007 23:48

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

Report message to a moderator

Re: more than one user [message #219557 is a reply to message #219556]

Thu, 15 February 2007 00:08

rzkhan
Messages: 370
Registered: March 2005

Senior Member

i get the message

FRM-40505: ORACLE error: unable to perform query

Report message to a moderator

Re: more than one user [message #219560 is a reply to message #219557]

Thu, 15 February 2007 00:13

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: more than one user [message #219563 is a reply to message #219560]

Thu, 15 February 2007 00:28

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

Report message to a moderator

Re: more than one user [message #219566 is a reply to message #219563]

Thu, 15 February 2007 00:31

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

Report message to a moderator

Re: more than one user [message #219569 is a reply to message #219563]

Thu, 15 February 2007 00:34

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

Report message to a moderator

Re: more than one user [message #219573 is a reply to message #219569]

Thu, 15 February 2007 00:42

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

Report message to a moderator

Re: more than one user [message #219575 is a reply to message #219573]

Thu, 15 February 2007 00:43

rzkhan
Messages: 370
Registered: March 2005

Senior Member

schemaname.username

schemaname.tablename

Report message to a moderator

Re: more than one user [message #219681 is a reply to message #219569]

Thu, 15 February 2007 07:36

Littlefoot
Messages: 21823
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)?

Report message to a moderator

Previous Topic:	Security Breach using DBSNMP user.
Next Topic:	PASSWORD_REUSE_TIME versus PASSWORD_REUSE_MAX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 08:57:32 CST 2024