0

I need to create a clone of a database owner.

I I have the following script:

create role oclone with password 'xxx' LOGIN INHERIT CREATEDB CREATEROLE;
grant dbowner to oclone;
alter role oclone set role dbowner;

I'm granting oclone ALL dbowner privileges and as an added check I'm setting oclone to act as dbowner role so it behaves EXACTLY THE SAME, in terms of object ownership and all other rights.

Are there any drawbacks to the above, or is this enough?:

create role oclone with password 'xxx' LOGIN INHERIT CREATEDB CREATEROLE;
grant dbowner to oclone;

Thanks

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.