Problems with privileges

Discussion created by Kreeves11674 on Mar 13, 2014
Latest reply on Mar 15, 2014 by mboeringa2010
I recently upgraded our Oracle database to 11g R2 ( and I am using ArcGIS 10.2 desktop and 10.2 database on a Windows 2008 server.  I created a new database and imported all of my existing users, roles, and data.  Before I could administer privileges, all of the users have viewing and editing rights of all of the datasets and tables in the db.  I revoked privileges through ArcCatalog and ArcToolbox, but it doesn't change the permissions.  Our database is a regional db with different government agencies as end users.  There are specific datasets that each agency is allowed to edit, and certain tables that only myself and the SDE user should be allowed to see.  But as it stands, everyone can see everything and can edit everything.  I am not sure what I am missing here, but I need to get this resolved before someone edits something that they should not be allowed to.  Any help would be greatly appreciated!