Difference between revisions of "From src"

14 bytes added ,  01:20, 6 February 2016
m
RESOURCE/CONNECT roles changed to more restricted set
m (RESOURCE/CONNECT roles changed to more restricted set)
Line 112: Line 112:
ALTER USER netxms QUOTA UNLIMITED ON USERS;
ALTER USER netxms QUOTA UNLIMITED ON USERS;
-- ROLES
-- ROLES
GRANT RESOURCE TO netxms;
GRANT CREATE SESSION, CREATE TABLE, CREATE PROCEDURE TO netxms;
GRANT CONNECT TO netxms;
</pre>
</pre>
create initial shema
create initial schema
  nxdbmgr init /usr/local/share/netxms/sql/dbinit_oracle.sql
  nxdbmgr init /usr/local/share/netxms/sql/dbinit_oracle.sql