ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '652501' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '652501' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '652501' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '652501' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '652501']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '652501'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 652501 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 652501]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 652501 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 652501

Título del libro: 2023 Mexican International Conference On Computer Science, Enc 2023
Título del capítulo: On the Decentralization of Attribute-Based Encryption Schemes

Autores UNAM:
ROCIO ALEJANDRA ALDECO PEREZ;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2023

---

Palabras clave:

Blockchain; Cloud storage; Cryptography; Internet of things; Sensitive data; Application scenario; Attribute-based encryption schemes; Attribute-based encryptions; Block-chain; Cloud services; Decentralisation; Multi-authority schemes; Permissioned blockchain; Storage requirements; Trusted authorities; Access control

---

Resumen:

Nowadays, cloud services are used for outsourcing the high processing and storage requirements demanded under Internet of Things (IoT) application scenarios. However, since cloud storage providers are not fully trustworthy, the major security concerns within this context are confidentiality and access control of outsourced sensitive data. In this sense, AttributeBased Encryption (ABE) is a type of cryptographically enabled access control that allows secure and fine-grained data-sharing with multiple users. With ABE, simultaneous provision of access control and confidentiality features is achieved by means of (1) access control policies used for data encryption, and (2) attribute sets that further describe the users' access capabilities. Despite the advantages provided by ABE, some issues still limit its efficient deployment in practical applications. One of these constraints is the centralized approach and dependency on a single trusted authority. In this work, we cope with the strong dependency of ABE schemes on a single trusted authority. Our decentralization approach aims to eliminate single points of failure by distributing between multiple entities the ABE trusted authority's tasks, namely users' secret key generation, and management. In this approach, we focus on a permissioned blockchain solution compliant with ABE typical deployments where system users are known and belong to specific organizational domains. © 2023 IEEE.

---

Entidades citadas de la UNAM:

---

Fuente:



ISBN:
9798350393156
Editorial:
Institute of Electrical and Electronics Engineers Inc.

Tipo de producto:
Conference Paper

DOI:
10.1109/ENC60556.2023.10508668