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
What are Schemas for? All of you are familiar with the default and built-in schema "dbo". When you create an object without a schema, "dbo" becomes the schema for the object. Generally, it is NOT considered a good practice from a manageability or security perspective to have everything owned by "dbo". The alternative is to … Continue reading SQL Server: Time To Switch Schema Of All Objects Away From “dbo”
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!