Hello SQL Gurus,
I want to create a trigger at the CDB level to restrict users being created with 'DEFAULT' profile. And if someone is creating a user using syntax (say)
'create user abc identified by password xyz'
and does not specify a profile, the trigger would fire and assign a profile predefined in the trigger body say
'alter user abc profile a-non-default-profile'.
And if a user uses the syntax as
'create user abc identified by password profile default'
The trigger should reject the create user request.
And I want this at the CDB level so that I don't have to worry about updating PDBs every time they get spun up.
How can I accomplish this?
Thanks a lot
aBBy