Oracle / SQL Server cheat sheet

OracleSqlServerCheat.md

###Set privs

Standard SQL:

GRANT SELECT|UPDATE|INSERT ON schema.object TO user

###Remove privs

Standard SQL:

REVOKE SELECT|UPDATE|INSERT ON schema.object FROPM user

###View privs

####ora

SELECT * FROM SYS.table_privileges;

###sql

slightly more complicated answer...

USE master;
SELECT dp.NAME AS principal_name
	,dp.type_desc AS principal_type_desc
	,o.NAME AS object_name
	,p.permission_name
	,p.state_desc AS permission_state_desc
FROM sys.database_permissions p
	LEFT OUTER JOIN sys.all_objects o ON p.major_id = o.OBJECT_ID
	INNER JOIN sys.database_principals dp ON p.grantee_principal_id = dp.principal_id