My customer's DBA has additional concerns about the CREATE privileges in the RESOURCE role. They have completed the bootstrap using an ID with the recommended privileges, and now they are looking to reduce these privileges. The customer will only ever be using short lived processes, so I believe they can remove the CREATE TABLE privilege, but what about the others?
CREATE SEQUENCE
CREATE CLUSTER
CREATE INDEXTYPE
Can these also be dropped if they are using SL processes only?
See original thread from techCommunity: http://tm.corp.adobe.com/techCommunity/viewtopic.php?f=59&t=5115&p=15133&hilit=oracle+privileges#p15...
Thanks,