mickyturbo
Fleissiger Benutzer
- Beiträge
- 54
Hi,
möchte gerne einen User names odb löschen.
Bekomme die Fehlermeldung:
Could not drop the role. FEHLER: kann Rolle „odb“ nicht löschen, weil andere Objekte davon abhängen DETAIL: 2 Objekte in Datenbank bdk
wenn ich mir allerdings die Tabellen anschaue von DB bdk sieht man das owner immer Postgres ist und nicht odb
bdk# \dt
Liste der Relationen
Schema | Name | Typ | Eigentümer
--------+---------------------------+---------+------------
public | __software_licenses_BAK | Tabelle | posters
public | _def_adaptertypes | Tabelle | postgres
public | _def_equipmenttypes | Tabelle | postgres
public | _def_softwaretypes | Tabelle | postgres
public | _std_sw | Tabelle | postgres
public | com | Tabelle | postgres
public | com_equipment | Tabelle | postgres
public | com_smartphone | Tabelle | postgres
public | comdata_simcard | Tabelle | postgres
public | equipment | Tabelle | postgres
public | equipment_net_old | Tabelle | postgres
public | equipmentdata_biospw | Tabelle | postgres
public | equipmentdata_inv | Tabelle | postgres
public | equipmentdata_imei | Tabelle | postgres
public | equipmentdata_login | Tabelle | postgres
public | equipmentdata_name | Tabelle | postgres
public | equipmentdata_priv_name | Tabelle | postgres
public | equipmentdata_room | Tabelle | postgres
public | equipmentdata_screenspecs | Tabelle | posters
public | equipmentdata_storage | Tabelle | postgres
public | exchainge_login | Tabelle | postgres
public | net_ipaddresses | Tabelle | postgres
public | net_macaddresses | Tabelle | postgres
public | net_routes | Tabelle | postgres
public | office_locations | Tabelle | postgres
public | office_netsockets | Tabelle | postgres
public | office_rooms | Tabelle | postgres
public | patchpanel_equipment | Tabelle | postgres
public | software_licenses | Tabelle | postgres
public | software_licenses_av | Tabelle | postgres
public | software_licenses_bp | Tabelle | postgres
public | software_licenses_ca | Tabelle | postgres
public | software_licenses_cl | Tabelle | postgres
public | software_licenses_hp | Tabelle | postgres
public | software_licenses_ma | Tabelle | postgres
public | software_licenses_me | Tabelle | postgres
public | software_licenses_mv | Tabelle | postgres
public | software_licenses_of | Tabelle | postgres
public | software_licenses_os | Tabelle | postgres
public | software_licenses_pe | Tabelle | postgres
public | software_licenses_sm | Tabelle | postgres
public | software_licenses_vp | Tabelle | postgres
public | software_licenses_zp | Tabelle | postgres
public | software_main | Tabelle | postgres
public | user_software_licenses | Tabelle | postgres
public | users | Tabelle | postgres
public | users_equipment | Tabelle | postgres
(47 Zeilen)
dank im voraus.
möchte gerne einen User names odb löschen.
Bekomme die Fehlermeldung:
Could not drop the role. FEHLER: kann Rolle „odb“ nicht löschen, weil andere Objekte davon abhängen DETAIL: 2 Objekte in Datenbank bdk
wenn ich mir allerdings die Tabellen anschaue von DB bdk sieht man das owner immer Postgres ist und nicht odb
bdk# \dt
Liste der Relationen
Schema | Name | Typ | Eigentümer
--------+---------------------------+---------+------------
public | __software_licenses_BAK | Tabelle | posters
public | _def_adaptertypes | Tabelle | postgres
public | _def_equipmenttypes | Tabelle | postgres
public | _def_softwaretypes | Tabelle | postgres
public | _std_sw | Tabelle | postgres
public | com | Tabelle | postgres
public | com_equipment | Tabelle | postgres
public | com_smartphone | Tabelle | postgres
public | comdata_simcard | Tabelle | postgres
public | equipment | Tabelle | postgres
public | equipment_net_old | Tabelle | postgres
public | equipmentdata_biospw | Tabelle | postgres
public | equipmentdata_inv | Tabelle | postgres
public | equipmentdata_imei | Tabelle | postgres
public | equipmentdata_login | Tabelle | postgres
public | equipmentdata_name | Tabelle | postgres
public | equipmentdata_priv_name | Tabelle | postgres
public | equipmentdata_room | Tabelle | postgres
public | equipmentdata_screenspecs | Tabelle | posters
public | equipmentdata_storage | Tabelle | postgres
public | exchainge_login | Tabelle | postgres
public | net_ipaddresses | Tabelle | postgres
public | net_macaddresses | Tabelle | postgres
public | net_routes | Tabelle | postgres
public | office_locations | Tabelle | postgres
public | office_netsockets | Tabelle | postgres
public | office_rooms | Tabelle | postgres
public | patchpanel_equipment | Tabelle | postgres
public | software_licenses | Tabelle | postgres
public | software_licenses_av | Tabelle | postgres
public | software_licenses_bp | Tabelle | postgres
public | software_licenses_ca | Tabelle | postgres
public | software_licenses_cl | Tabelle | postgres
public | software_licenses_hp | Tabelle | postgres
public | software_licenses_ma | Tabelle | postgres
public | software_licenses_me | Tabelle | postgres
public | software_licenses_mv | Tabelle | postgres
public | software_licenses_of | Tabelle | postgres
public | software_licenses_os | Tabelle | postgres
public | software_licenses_pe | Tabelle | postgres
public | software_licenses_sm | Tabelle | postgres
public | software_licenses_vp | Tabelle | postgres
public | software_licenses_zp | Tabelle | postgres
public | software_main | Tabelle | postgres
public | user_software_licenses | Tabelle | postgres
public | users | Tabelle | postgres
public | users_equipment | Tabelle | postgres
(47 Zeilen)
dank im voraus.