Grant rights by script

Database
Enthusiast

Grant rights by script

Hi,

I have created a database B as clone to database A, but this not carry the rights from A to B.

Then i try to insert by script the rights on DBC.AccessRights this give me an error :
"The user does not have INSERT access to DBC.AccessRights" , but the user is DBC...

Whose i can replicate the rights from an object A to an object B by script ?

Regards.
2 REPLIES
Enthusiast

Re: Grant rights by script

Select rows from DBC.AccessRights and generate proper "GRANT ... TO ..." SQL statements to be then executed...
Enthusiast

Re: Grant rights by script

Hi DGiabbai,

OK, this is correct.

BR.