Modify Program.cs to include your DB connection information:."CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE MATERIALIZED VIEW TO " + user + "') " +Ĭonsole.WriteLine(user + " user created") "EXECUTE IMMEDIATE ('GRANT CREATE SESSION, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, " + " DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS') " + "EXECUTE IMMEDIATE ('CREATE USER " + user + " IDENTIFIED BY " + pwd +
Modify the anonymous PL/SQL GRANT command if you wish to modify the privileges granted Using (OracleCommand cmd = con.CreateCommand())Ĭonsole.WriteLine("Successfully connected to Oracle Database") Using (OracleConnection con = new OracleConnection(conStringDBA)) Check whether DBA Privilege is required.ĬonStringDBA = "User Id=" + sysUser + " Password=" + sysPwd + " Data Source=" + db + " " ĬonStringDBA = "User Id=" + sysUser + " Password=" + sysPwd + " DBA Privilege=" + role + " Data Source=" + db + " " Set the demo user id, such as DEMODOTNET and password If admin has no role, then set to empty string Provide the DBA's user id, password, and role to create the demo user such as "localhost/XEPDB1" for 18c XE or higher Set the net service name, Easy Connect, or connect descriptor of the pluggable DB,
0 kommentar(er)
