Skip to Content
0
Jun 05, 2020 at 07:01 AM

granting user to create objects in another user schema

120 Views Last edit Jun 05, 2020 at 07:13 AM 2 rev

Dear Sirs, I'm new in SAP and can't understand one simple thing.

For Example we have a user alfa who has object alfa.table

Then we create user beta and give him rights (grant all to beta)

Now user beta can create table2 as owner, but can't create such table under schema alfa.

1)How we can grant user beta to create alfa.table2. Can we?

2) And can we grant privileges to create only in schemas of users beta and alfa?