search

fullstackhero / dotnet-starter-kit

Production Grade Cloud-Ready .NET 8 Starter Kit (Web API + Blazor Client) with Multitenancy Support, and Clean/Modular Architecture that saves roughly 200+ Development Hours! All Batteries Included.
https://fullstackhero.net/dotnet-webapi-boilerplate/
MIT License
5.22k stars 1.56k forks source link

ORA-01435: user does not exist ORA-06512: at line 8 #571

Closed iamamjadabdullah closed 2 years ago

iamamjadabdullah commented 2 years ago

While using oracle database exception occur. Below is connect string. Database is fine and can be connected with PL SQL. Kindly help to this. Let me know if further information required.

{ "DatabaseSettings": { "DBProvider": "oracle", "ConnectionString": "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA =(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=demo_db;Password=netsolpk" } }

frankyjquintero commented 2 years ago

https://github.com/fullstackhero/dotnet-webapi-boilerplate/issues/225

frankyjquintero commented 2 years ago

If the system has more than one schema in its definition, you must create a user for each one and give the base user permissions to manipulate them.

remember that schemas in oracle correspond to users

stale[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.