how to get ddl of users and roles Archives - orakldba

How to Generate user ddl in Oracle

July 20, 2023January 3, 2021 by Prasanta

Generate user ddl in Oracle: In this article we will discuss about how to Generate user ddl in Oracle. You can use below scripts to generate DDL statements for a user or multiple users with their roles, system and object privileges. To generate ddl for a specified user: In this case we generate ddl for … Read more