Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Tags:
replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question