Postgres user/role drop

Posted by Grasper on Stack Overflow See other posts from Stack Overflow or by Grasper
Published on 2010-03-18T01:38:23Z Indexed on 2010/03/18 2:21 UTC
Read the original article Hit count: 729

I am trying to drop a user:

drop user testUser;

I want to force this to work in a simple manner (Not a million calls)... How can I do this easily?

I get this output:

ERROR:  role "testUser" cannot be dropped because some objects depend on it
DETAIL:  access to table main.tap_db_version
access to table main.user_instance
access to table main.target_type
access to table main.status_code
access to table main.state_space_profile
access to table main.service_subscription
access to table main.service_instance
access to table main.sa_ordnance_weapon_type
access to table main.operation
access to table main.mission_class
access to table main.map_symbol
access to table main.ada_weapon_type
access to table main.active_process
access to table main.acft_type_00_only
access to table main.abp_create_params
access to table main.exercise
access to table main.decl
access to table main.data_set
access to table main.cancellation_notice
access to table main.ato_family_tree
access to table main.apportionment_cat_cd
access to table main.abp
access to table main.alert_settings
access to table main.alert_log
access to table main.airspace_usage_category
access to schema main
access to view testUser.top_priority
access to view testUser.target_ssm_msn_count
access to view testUser.target_air_msn_count
access to view testUser.sortie_sum
access to view testUser.ref_info
access to view testUser.preview_rmk_count
access to view testUser.preview_pgm_las_count
access to view testUser.preview_pgm_desi_count
access to view testUser.preview_objective_count
access to view testUser.preview_gfriend_count
access to view testUser.preview_escort_msn_req
access to view testUser.preview_chaff_data
access to view testUser.preview_airmove_seg
access to view testUser.preview_aircraft_total
access to view testUser.offload_total
access to view testUser.objective_count
access to view testUser.fuel_planned
access to view testUser.ew_data
access to view testUser.dual
access to view testUser.current_base_inventory
access to view testUser.cell_total
access to view testUser.asgn_sortie_sum
access to view testUser.appor_sorties_planned
access to view testUser.airmove_seg
access to view testUser.aircraft_total
access to view testUser.abp
access to table testUser.req_msn_task
access to table testUser.req_task_source_req
access to table testUser.req_ssm_msn
access to table testUser.req_ssm_source
access to table testUser.req_msn
access to table testUser.req_msn_warnings
access to table testUser.req_air_msn
access to table testUser.req_src_header
access to table testUser.req_msn_ids
access to table testUser.req_msn_comment
access to table testUser.req_c2_msn
access to table testUser.req_c2_source
access to table testUser.req_ada_msn
access to table testUser.req_ada_vertex
access to table testUser.weather_forecast
access to table testUser.weather_coords
access to table testUser.weather_area
access to table testUser.weapon_option
access to table testUser.wag_activity
access to table testUser.unit_remark
access to table testUser.unit_location_turn
access to table testUser.unit_iff
access to table testUser.unit_coordination
access to table testUser.unit_code
access to table testUser.trace_point
access to table testUser.tasking_agency
access to table testUser.task_unit
access to table testUser.target_type
access to table testUser.tap_db_version
access to table testUser.status_code
access to table testUser.state_space_threat
access to table testUser.state_space_profile
access to table testUser.state_space
access to table testUser.ssm_mission
access to table testUser.spins_section_id
access to table testUser.spins_codes
access to table testUser.spins
access to table testUser.unit_location
access to table testUser.ship_target_request
access to table testUser.service_subscription
access to table testUser.service_instance
access to table testUser.sa_ordnance_weapon_type
access to table testUser.runway
access to table testUser.restricted_codes
access to table testUser.response_entity
access to table testUser.residual_mission
access to table testUser.request_objective
access to table testUser.request
and 194 other objects (see server log for list)

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about sql