HANA Studio User - Similar to SYSTEM User

[anandrd]

Dear Experts,

We created a new user(IWSYSTEM) in HANA for Accessing B1 Company databases, we assigned the the Object privilege's for the specific user and the was able to access the B1 Company databases only assigned to that user.

If any new B1 Company databases has been Created/ or a old DB restored, the new user IWSYSTEM is unable to access the created/restored B1 database.

In order to access that, we need to login with SYSTEM User and assign the object privilege for the B1 Schema (Company database) for the user IWSYSTEM, then only the new user IWSYSTEM is able to access.

Is it possible to assign any superuser privilege to the HANA user, so that whenever a new B1 Schema is restored the new user(IWSYSTEM) should also have access to it.

Basically our idea is not to use SYSTEM user, instead create a mirror access for SYSTEM User and use it for our purpose.

Kindly advise how to apply necessary privileges.

Thanks

Anand

[Cocquerel · Accepted solution]

When you create new schema, you may define user IWSYSTEM has owner with statement like:
CREATE SCHEMA <SchemaName> OWNED BY IWSYSTEM
Doing that user IWSYSTEM will have full privileges on the newly created schema

[anandrd · Accepted solution]

Thanks for your suggestion Michael, so basically we need to assign authorisation for a new schema which has been imported, please correct me if my understanding is incorrect.

[Cocquerel · Accepted solution]

Yes Anand,
even SYSTEM user does not have access to all schemas.
The prerequisite is to either be the owner of the schema or have been granted access by an other user having already access to it with "grant to others" option.
You can check "SYS"."OWNERSHIP" view to see who is the owner.
If you are using IMPORT statement to create your schema, I suppose the OWNER will be the one running the IMPORT statement.

Regards,
Michael