As an Oracle DBA, you are very likely to get requests somewhat like this: Create an account for Sam Hill. The privileges should look exactly like Rob Nixon. If you are not into automating everything, your first instinct would be to fire-up an IDE like Toad or SQL Developer and script out the source user, … Continue reading Oracle: Clone An User With PL/SQL – Tablespace Quotas, Role Grants/Default Role, Object Grants And System Grants
Permissions are complex! Permissions management is not easy. You have a lot to deal with Direct user privileges via grants Privileges to AD Group login of which user is part of User could be part of multiple AD groups which have a login on the instance Privileges granted to the role that user is in … Continue reading SQL Server – Find Effective Permissions of An User At Database, Server or Object Level – The Right Way!