###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