Home » RDBMS Server » Security » user permission
user permission [message #192312] Mon, 11 September 2006 15:36 Go to next message
oracle2006
Messages: 2
Registered: September 2006
Junior Member
Hello,

I am a newbie and I hope someone could help me with a permission problem.

I am working on user permission project in RMS. As an administrator, I can authorises users three options: WRITE, READ, NO ACCESS to the database. And for each user, they will have three functions: Administration, Bank transfer, ledger view.

Every time when we change the user's administration to WRITE, all the other two functions: Bank transfer and ledger view, should be changed to WRITE.

However, after running the SQL the other two functions haven't be changed to WRITE.

So how can we solve the problem? I am totally lost. Hope someone can help me with this.

Thanks.

Oracle2006 Embarassed
Re: user permission [message #192344 is a reply to message #192312] Tue, 12 September 2006 00:16 Go to previous messageGo to next message
Liza79
Messages: 74
Registered: September 2006
Member
Please give a little touch of yor technique to do it.


I will be definitly try using ROLES for such requirement.

Liza
icon9.gif  Re: user permission [message #192536 is a reply to message #192344] Tue, 12 September 2006 15:41 Go to previous messageGo to next message
oracle2006
Messages: 2
Registered: September 2006
Junior Member
thanks very much for your quick response!!

I think I need read more about ROLE in order to get some background about this.

But I feel a little depressed because I only know the basic SQL: SELECT xxx FROM xxx WHERE xxx.

So how can I add this ROLE into my SQL language in order to help it running.

Oracle2006

Re: user permission [message #192538 is a reply to message #192312] Tue, 12 September 2006 15:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
When all else fails try reading the fine Concepts Manual found at http://tahiti.oracle.com
Re: user permission [message #192539 is a reply to message #192312] Tue, 12 September 2006 15:45 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
When all else fails try reading the fine Concepts Manual found at http://tahiti.oracle.com
Previous Topic: Copying a user
Next Topic: Manage users for multi databases
Goto Forum:
  


Current Time: Thu Mar 28 21:23:17 CDT 2024