creating super admin user in Oracle
OR
Create user with admin option
-- To create user
create user applsys
identified by xxxxx
default tablespace USERS
temporary tablespace TEMP
profile default;
grant CONNECT to applsys;
GRANT dba TO applsys WITH ADMIN OPTION;
Some theory :
WITH GRANT OPTION :
Specify WITH GRANT OPTION to enable the grantee to grant the object privileges to other users and roles.
Restriction on Granting WITH GRANT OPTION :
You can specify WITH GRANT OPTION only when granting to a user or to PUBLIC, not when granting to a role.
WITH HIERARCHY OPTION :
Specify WITH HIERARCHY OPTION to grant the specified object privilege on all subobjects of object, such as subviews created under a view, including subobjects created subsequent to this statement.
This clause is meaningful only in combination with the SELECT object privilege.
OR
Create user with admin option
-- To create user
create user applsys
identified by xxxxx
default tablespace USERS
temporary tablespace TEMP
profile default;
grant CONNECT to applsys;
GRANT dba TO applsys WITH ADMIN OPTION;
Some theory :
WITH GRANT OPTION :
Specify WITH GRANT OPTION to enable the grantee to grant the object privileges to other users and roles.
Restriction on Granting WITH GRANT OPTION :
You can specify WITH GRANT OPTION only when granting to a user or to PUBLIC, not when granting to a role.
WITH HIERARCHY OPTION :
Specify WITH HIERARCHY OPTION to grant the specified object privilege on all subobjects of object, such as subviews created under a view, including subobjects created subsequent to this statement.
This clause is meaningful only in combination with the SELECT object privilege.
Consulting services provided by GenexDBS
ReplyDeleteBusiness advisory firms in India help us detect and solve problems, but they can also protect us from threats and provide us with innovative ideas to improve the stability and profitability of our businesses. Database Security
In an IT context, Genexdbs' 24/7 support is referred to as 24/7 support. This term covers a wide range of IT services, including server monitoring, call center support, and database support. A typical example of this kind of support is maintenance of services that must run continuously.
Businesses can outsource the administration of their database platforms to GenexDB's remote DBA service. A business that offers a remote service from its location is known as a remote service.
According to established standards, independent third parties monitor and administer the designated database server installation as part of remote DBA services. Among other tasks, DBAs monitor database space, memory levels, CPU utilization, handle error log alerts, and verify backups.
Remote monitoring can be performed in a variety of ways by DBAs. Admins can manage it through individual connections. Monitoring a database's performance can be done remotely. It is also possible to create a script to collect system performance and health data, which is then sent to the database administrator for review.