cancel
Showing results for 
Search instead for 
Did you mean: 

User for existing Schema

italo_naia
Participant
0 Kudos

Hi All,

  There is an away to create a user with the name of existing Schema without drop Schema?

   I Create a Schema AAA with user Y, now I want create a User 'AAA' to work with Schema 'AAA'.

Thank All.

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

>There is an away to create a user with the name of existing Schema without drop Schema?
No, because when you create a user a schema with the same name is automatically created in the system. This is supposed to be a special type of schema that should only be used to store temporary objects for the user in question.  This is why the system blocks you if it sees there is already a schema with the same name created in the system.

Answers (2)

Answers (2)

former_member182302
Active Contributor
0 Kudos

Not possible in SAP HANA

Regards,

Krishna Tangudu

patrickbachmann
Active Contributor
0 Kudos

Is there a reason you want it to have the same name?  You could just assign access to schema AAA to user AAA.  When you create a schema via SQL console you can assign owner there as well like this;

CREATE SCHEMA SCHEMANAMEHERE OWNED BY USERNAMEHERE

-Patrick

italo_naia
Participant
0 Kudos

I already have the Schema 'AAA' now I need create a user with name 'AAA' and I cant because the schema exists.

Former Member
0 Kudos

Hi,

I don't think it's possible in SAP HANA.

Best regards,

Wenjun