Hi...
we use the Server script generator as one daily business to re-create a user or to create a similar one on a different instance. Is it possible to script the object-grants of a user? The roles and system-grants are scripted in the output. But the objects grants are missing.
I think the view "DBA_TAB_PRIVS is the one to select.
Here an example: select distinct 'GRANT '||privilege||' ON '||OWNER||'.'||TABLE_NAME||' TO '||GRANTEE from DBA_TAB_PRIVS where GRANTEE in ('SCOTT','USER1'); Only "with grant option" or not is missing.
Perhaps you can build it in, it would be a facilitation.
Thanks,
Jens
@ivan: can you look into it ?
Adding object level permissions here will definitely slow things down, thought I definitely agree that it would be of huge benefit to the user. We can add a check box with [Default: false]; Checking this box will cause a considerable increase in the time it takes to extract the information.
Currently: You can extract object level permissions on a user from the Tree Node by right clicking on the user and Executing the Script Object GRANT.
Adding object level permissions here will definitely slow things down, thought I definitely agree that it would be of huge benefit to the user. We can add a check box with [Default: false]; Checking this box will cause a considerable increase in the time it takes to extract the information.
Currently: You can extract object level permissions on a user from the Tree Node by right clicking on the user and Executing the Script Object GRANT.
Code is complete but waiting on discussion before code check in. As of now, I have enabled this for Oracle only.
Code is complete but waiting on discussion before code check in. As of now, I have enabled this for Oracle only.
Added warning message next to check box. Also check box will only be available for oracle and if users are selected. This can be enhanced in the future if support for roles or other databases need to be added, but I would file it as a separate issue and link this issue to it.
Added warning message next to check box. Also check box will only be available for oracle and if users are selected. This can be enhanced in the future if support for roles or other databases need to be added, but I would file it as a separate issue and link this issue to it.
Please provide ADS build number to verify the issue.
Please provide ADS build number to verify the issue.
Issue #12869 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v16.0.0-dev-69 |
No time estimate |
@ivan: can you look into it ?