Subject | About SYSDBA super user |
---|---|
Author | palermo19992000 |
Post date | 2004-12-23T12:03:43Z |
Hello at all
Tank to Ivan for all info about security. I using the info in
message number 52783 as below:
"
CREATE DATABASE 'd:\db.fdb' USER 'NAMIT' PASSWORD 'x5f4g4r8d5c4';
CREATE ROLE SYSDBA;
"
I created a database with another user than SYSDBA and I create role
SYSDBA.
Ok now I cannot enter with SYSDBA user but only with a valid user,
The Problem is that the database owner not is a super user as SYSDBA
and it can manages only its objects, not all objects as SYSDBA.
again
It Is right that in "regular" database (with SYSDBA super user) and
in modified (without SYSDBA super user) a user without privileges
can add another new user even if it cannot assign provileges to this
new user?
Tanks at all, Merry Chrismas and happy new year
Luigi
Tank to Ivan for all info about security. I using the info in
message number 52783 as below:
"
CREATE DATABASE 'd:\db.fdb' USER 'NAMIT' PASSWORD 'x5f4g4r8d5c4';
CREATE ROLE SYSDBA;
"
I created a database with another user than SYSDBA and I create role
SYSDBA.
Ok now I cannot enter with SYSDBA user but only with a valid user,
The Problem is that the database owner not is a super user as SYSDBA
and it can manages only its objects, not all objects as SYSDBA.
again
It Is right that in "regular" database (with SYSDBA super user) and
in modified (without SYSDBA super user) a user without privileges
can add another new user even if it cannot assign provileges to this
new user?
Tanks at all, Merry Chrismas and happy new year
Luigi