I must create a user and role in my schema before deploying the application.
The way I was going about this was inserting a new row into the applications table like so :
INSERT INTO ORA_ASPNET_APPLICATIONS (ApplicationName, LoweredApplicationName, ApplicationId, Description) VALUES ('Security', 'security', default , 'Security App');
Designating 'default' for the SYS_GUID/Raw Column.
The next step is that I must create a new role and a new user for this role.
In Sql Server, I was simply designating the Guid for the respective columns in each row, but with Oracle, I belive a more elegant solution is needed.
Two options - select the SysGuid out of the applications table row, and use that value for the other applicationid columns in Users and Roles ?
Execute the Create User and Create Role Function
I am new to Oracle, and Am not sure of the standard for executing either of them - any one have any examples / suggestions ?