Skip to Content

User for existing Schema

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jan 13, 2015 at 01:00 PM

    >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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 13, 2015 at 10:30 AM

    Not possible in SAP HANA

    Regards,

    Krishna Tangudu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 12, 2015 at 04:32 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.