Duplicate Schema error.

[Former Member]

Hi Experts,

     I have two users SYSTEM, CUSER. In SYSTEM user I have EFASHION_TUTORIAL schema. I'm trying to create same schema in CUSER. but system is showing "Duplicate Schema error". But i want to access EFASHION_TUTORIAL schema in CUSER. Please any one suggest me the solution. Please tell me the reason why I'm getting this error.

Thanks,

Vishali Raghava Raju.

[rama_shankar3]

Vishali,

Technically, it should be possible but System use might be the problem in your scenario. Create another user ID as a 2nd user and try it. I remember creating a duplicate schema name under 2 separate users in the past...last year..not sure if I used system..try without system...user

Rama

[Former Member]

Hi Vishal,

From my experience, it is not possible to duplicate Same Schema Name.

But I would like to suggest you to Grant Privileges to used Efashion_Tutoral Schema to Cuser.

Try opening the user SYSTEM from the HANA Studio - Catalog - Authorization - Users  and double click the user and under the SQL Privileges Add the schema and select the necessary permission for the user on that schema. Then, you can see Efashion_Tutioral schma under CUSER.

br,

Sulabh Bartaula