Skip to Content

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

Drop user schema/revoke to own schema

Hi everyone,

Just wondering whether it is possible to either drop an active users schema or at least revoke all privileges for a user on their own schema. Basically we have some users we do not want to be able to create objects, but are granted select privileges to a different schema where all data is maintained. Seems like a fairly simple thing but I cannot find any info on whether this is able to be done.

Thanks,

Mark.

Former Member
Former Member replied

So, you can use "CREATE RESTRICTED USER XXX PASSWORD XXX".

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