create schema with all privileges

[Former Member]

hi

I am creating Schema using following sql commands  with SYSTEM as user

Create Schema Live2;

CREATE COLUMN TABLE "Connections" (

"memberIdFrom" INTEGER NOT NULL,

"memberIdTo" INTEGER NOT NULL,

PRIMARY KEY ("memberIdFrom","memberIdTo")

);

Then I goto

Security-->users-->SYSTEM-->object privileges

there is not schema Live2 there

When I add LIVE2 then it's privileges are set to CREATE ANY only

Why this is happening?

I think by default user should have all privileges.

If i try to assign privileges then error exception occurs that Granter and Grantee are identical.

[Former Member]

Hi Khalid,

Ideally when you execute sql 'create schema <schema_name>' then the logged in user is going to default owner of the schema and you should see that under 'object privileges' of that user.

The user will have 'create any' privileges which means the user has all the privileges on that schema.

if you want to check who is owner of the schema in the system, please check 'SCHEMAS' under views in SYS.

Regards,

Venkat N.