Skip to Main Content
  • Questions
  • Can i give different permission SELECT/INSERT to same Schema for different application in one database?

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Karishma.

Asked: February 23, 2018 - 9:10 pm UTC

Last updated: February 25, 2018 - 7:51 am UTC

Version: Oracle 11gR2

Viewed 1000+ times

You Asked

Hi sir,

I am DBA and now i stuck in one situation,
I have one database and 3 different application, data will be come from one application and I need to store
those data in one schema. Now, Scenario is 2 application can have read only access and one have read and
write both privileges.

What should i do?

Thank you in advance!

and Connor said...

So if I'm reading this correctly - you could be taking about this:

Schema1: data
Schema2: needs to read data from schema1
Schema3: needs to read/write from schema1

Not sure what the issue is here. You do the appropriate grants (select) to schema2, and appropriate grants (select,insert,update,delete) to schema3.

Or, you could be talking about this:

Schema1: data
Schema2: application X connects as schema2, and needs read access
application Y connects as schema2, and needs read/write access

In this case, create a role for READ and a role for READ/WRITE and protect the second role with a password. When connections occur as "schema2", if it is application X it does nothing, if it is application Y, then it does "set role read-write identified by password" to gain access to the read/write privs.

Given the incredibly brief description you have us :-( that is really all I can deduce from this.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thank you so much

Karishma, February 25, 2018 - 4:58 am UTC

I am very thankful to you. I really very very appreciated your response
Once again, Thank you so much.
Connor McDonald
February 25, 2018 - 7:51 am UTC

glad we could help

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.