Oracle Database Application User

[BrownZeus]

Hey all,

 

I have an assignment where I store user data into an Oracle Database (I have to use Oracle DB). I  understand that I can create application users that are not schema owners, however the online documentation is quite confusing or unclear.

 

Can anyone point me in the right direction? An simple and well explained how-to or tutorial?

 

Thanks in Advance!

 

EDIT!-----------------------------------------------------------------------------

 

So I figured out why I was having trouble following the documentation example, and it involves where I'm hosting my Oracle Server.

I'm using a free tier of AWS's RDS Oracle DB, and as a result I don't have the privileges I need to create application users. Does anyone have an idea on how I could do username+password log in with my users?

 

I WANT LOGIC NOT CODE.

 

This is a homework assignment not a real-world application.

[vorticalbox]

Is this a limitation of aws? I assume you have admin roles on aws? 

 

What programming language are you using?

 

I tend to just use a docker image if I need to test stuff with databases so might be worth looking into that.

[BrownZeus]

5 hours ago, vorticalbox said:

Is this a limitation of aws? I assume you have admin roles on aws? 

 

What programming language are you using?

 

I tend to just use a docker image if I need to test stuff with databases so might be worth looking into that.

So I have to use AWS RDS as requirement of the assignment. My program (written in java) is going to check for log in validity by running a query that selects * from table where user = username AND password=pw, if the query result is 0 then its failed or the account does not exist

 

RDS doesn't allow SYSDBA to the customer (me) so if I want SYSDBA i'd have to use EC2 and such. I don't have the time to learn all that. So just going to have to do it the primitive way

[vorticalbox]

2 hours ago, BrownZeus said:

So I have to use AWS RDS as requirement of the assignment. My program (written in java) is going to check for log in validity by running a query that selects * from table where user = username AND password=pw, if the query result is 0 then its failed or the account does not exist

 

RDS doesn't allow SYSDBA to the customer (me) so if I want SYSDBA i'd have to use EC2 and such. I don't have the time to learn all that. So just going to have to do it the primitive way

This may help

 

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToOracleInstance.html

[BrownZeus]

9 hours ago, vorticalbox said:

This may help

 

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToOracleInstance.html

Unfortunately, it does not. What I wanted was for the database server itself to handle log in vlaidation for me through application users, but the only way to set up application users is to have a user that has sysdba permissions, not regular dba.

 

Thank you for trying to help! I have to accept that I can't do it the way I'd like to because of the limitations of my required DB implementation