Role
Download as odp, pdf0 likes532 views
T¨¤i li?u gi?i thi?u v? database roles trong PostgreSQL, bao g?m c¨¢ch t?o v¨¤ x¨®a roles c¨´ng v?i c¨¢c thu?c t¨ªnh c?a ch¨²ng nh? login, superuser, v¨¤ capabilities kh¨¢c. N¨® c?ng gi?i th¨ªch c¨¢c kh¨¢i ni?m v? role membership, c¨¢ch qu?n l? quy?n h?n gi?a c¨¢c role v¨¤ c¨¢ch c?m th?a k? quy?n h?n. Cu?i c¨´ng, t¨¤i li?u cung c?p c¨² ph¨¢p cho vi?c th?c hi?n c¨¢c ch?c n?ng n¨¤y m?t c¨¢ch an to¨¤n v¨¤ hi?u qu?.
1 of 16
Downloaded 17 times
![Postgresql www.elarion.com [email_address] Never stop improving quality](https://image.slidesharecdn.com/role-110926041130-phpapp01/85/Role-1-320.jpg)
Ad
Recommended
Finsight - Private Equity in India: Recent observations and emerging trends a...
Finsight - Private Equity in India: Recent observations and emerging trends a...South Asia Fast Track
?
This document discusses private equity in India, including recent trends, challenges, and strategies. It notes that while PE activity levels have increased over the past decade, challenging economic conditions have impacted returns. Both investors and fund managers have adapted their approaches in response, such as focusing on management quality and differentiated strategies. The document also examines trends in fundraising, deal sourcing and due diligence, valuations, sectors and geographies.Murli cement
Murli cementAkhil Jain
?
The document outlines various marketing strategies employed by Murli Cement to enhance brand visibility, including wall paintings, hoardings, and vehicle branding in Nagpur. It emphasizes engagement with dealers and masons to promote brand trust and awareness, while also detailing merchandising efforts. Plans for expansion into new states and a repositioning campaign centered around trust are also discussed.Deselction
DeselctionErnani Agulto
?
When libraries reach the limits of their collection space, they have three options: expand their physical facilities, divide the collection which requires additional space, or weed the collection which may or may not require new space. Weeding, or deselection, involves removing materials that are no longer useful or in demand from the primary collection area. Materials can be disposed of through exchange programs, sales, or storage in secondary access areas. The main reasons for weeding library collections are to ensure the accuracy and currency of information, remove items in poor physical condition, free up needed space, and remove unused duplicate or outdated items.§²§å-§è§Ö§ß§ä§â
§²§å-§è§Ö§ß§ä§â§¥§Ö§ß§Ú§ã §®§Ú§Õ§Ñ§Ü§à§Ó
?
§¥§à§Ü§å§Þ§Ö§ß§ä §à§Ò§ã§å§Ø§Õ§Ñ§Ö§ä §Ó§Ñ§Ø§ß§à§ã§ä§î §Õ§à§Þ§Ö§ß§ß§í§ç §Ú§Þ§Ö§ß §Ú §ç§à§ã§ä§Ú§ß§Ô§Ñ §Õ§Ý§ñ §å§ã§á§Ö§ê§ß§à§Ô§à §Ù§Ñ§á§å§ã§Ü§Ñ §Ó§Ö§Ò-§ã§Ñ§Û§ä§à§Ó, §Ñ§Ü§è§Ö§ß§ä§Ú§â§å§ñ §Ó§ß§Ú§Þ§Ñ§ß§Ú§Ö §ß§Ñ §â§Ñ§Ù§Ý§Ú§é§Ú§Ú §Þ§Ö§Ø§Õ§å §ß§Ñ§è§Ú§à§ß§Ñ§Ý§î§ß§í§Þ§Ú §Õ§à§Þ§Ö§ß§Ñ§Þ§Ú §Ú §Ú§ç §â§Ö§Ô§Ú§ã§ä§â§Ñ§è§Ú§Ö§Û. §´§Ñ§Ü§Ø§Ö §â§Ñ§ã§ã§Þ§Ñ§ä§â§Ú§Ó§Ñ§ð§ä§ã§ñ §á§â§à§Ò§Ý§Ö§Þ§í, §ã§Ó§ñ§Ù§Ñ§ß§ß§í§Ö §ã §á§à§ä§Ö§â§Ö§Û §Õ§à§Þ§Ö§ß§à§Ó §Ú §ã§á§à§ã§à§Ò§í §ã§ß§Ú§Ø§Ö§ß§Ú§ñ §â§Ú§ã§Ü§à§Ó, §Ó§Ü§Ý§ð§é§Ñ§ñ §ð§â§Ú§Õ§Ú§é§Ö§ã§Ü§Ú§Ö §Ñ§ã§á§Ö§Ü§ä§í §Ú §â§Ö§ê§Ö§ß§Ú§ñ §Õ§à§Þ§Ö§ß§ß§í§ç §ã§á§à§â§à§Ó. §£ §Ù§Ñ§Ü§Ý§ð§é§Ö§ß§Ú§Ö, §ã§à§Õ§Ö§â§Ø§Ñ§ä§ã§ñ §â§Ö§Ü§à§Þ§Ö§ß§Õ§Ñ§è§Ú§Ú §á§à §Ó§í§Ò§à§â§å §ç§à§ã§ä§Ú§ß§Ô-§á§â§à§Ó§Ñ§Û§Õ§Ö§â§à§Ó §Ú §ä§Ñ§â§Ú§æ§à§Ó §Ó §Ù§Ñ§Ó§Ú§ã§Ú§Þ§à§ã§ä§Ú §à§ä §ä§Ú§á§Ñ §ã§Ñ§Û§ä§Ñ.Format mingguan
Format mingguanLavendar Craft
?
Dokumen ini merangkumi kursus BBM 3105 mengenai pengajaran dan pembelajaran bahasa Melayu berbantukan komputer di IPG Tengku Ampuan Afzan. Ia membincangkan garis panduan dan etika penggunaan internet, dan menerangkan cara untuk memindahkan maklumat tersebut dalam bentuk brosur dan pembentangan PowerPoint. Tarikh dan waktu sesi adalah pada 09/01/2013 dari 10.30 pagi hingga 1.30 petang.Photoshoot ppt for blog
Photoshoot ppt for blogjessiekeegan
?
The document discusses selecting a background and photo for a magazine cover. Several background options were tested, including a red brick wall, concrete, and plain white, but most did not work well. A photo with a model against a brick wall was chosen as the final image because the colors and linear brick pattern provide guidance for text while still standing out clearly. The model's expression of confusion also fits the desired mood.Convocatoria Concurso de Prototipos 2013CBTIS No. 48
?
Convocatoria del proceso para concurso de prototiposEl P¨¨sol Negre. N¨²mero 1. Mar? 2008 (1a ¨¨poca)
El P¨¨sol Negre. N¨²mero 1. Mar? 2008 (1a ¨¨poca)Cgtmanresa Bages
?
El P¨¨sol Negre. N¨²mero 1. Mar? 2008Email
EmailQudsi Falkhi
?
Dokumen ini membahas tentang pengertian email dan sistem kerjanya. Email merupakan fasilitas surat elektronik melalui internet yang pertama kali dikembangkan oleh Ray Tomlinson pada tahun 1971 dengan menggunakan tanda ¡°@¡± untuk memisahkan user ID dan domain pada alamat email. Ada beberapa jenis email seperti POP mail yang menyimpan email secara offline, web-based mail yang dapat diakses dimana saja melalui internet, dan email forwarding yang meneruskan email keContinental philosophy
Continental philosophytjmartin72768
?
This document provides an overview of analytic vs continental philosophy, highlighting their differing views on the role of science and emphasis on history/context. It then summarizes several articles and ideas within continental philosophy, including:
1) Richard Rorty linking American pragmatism with hermeneutics and arguing they both reject Platonic absolutism in favor of tradition-bound truths.
2) Nietzsche's criticism of Platonic reason and objectivity, arguing truth is contextual and interpretation-based.
3) Hermeneutics and social constructivism viewing truth as emerging from and conditioned by language, culture, and social structures.
4) Both strengths and challenges of the hermFirst British Settlers
First British SettlersCyntia Oca?as
?
The document outlines several major events and social changes in British history from the earliest settlers through the 20th century:
1) Celtic tribes arrived in Britain in the 5th century BCE and established societies led by kings with Druids serving important religious roles. The Romans then invaded in 43 CE and controlled much of the island.
2) Anglo-Saxons invaded beginning in the 5th century CE and established several kingdoms that were eventually united under King Alfred. Vikings then raided parts of Britain beginning in 793 CE.
3) The Norman invasion in 1066 CE introduced feudalism and manorialism. Over subsequent centuries, events like the Industrial Revolution, world wars, and reform acts broad½â¶Á´¡±è±èÐÂÇ÷ÊÆ£¬ÔËÓô¡±è±èÓ®µÃ¸ü¶àÉÌ»ú£¡
½â¶Á´¡±è±èÐÂÇ÷ÊÆ£¬ÔËÓô¡±è±èÓ®µÃ¸ü¶àÉÌ»ú£¡Leo Lin
?
±¾ÎļþÌÖÂÛÁËÓ¦ÓóÌÐò£¨²¹±è±è£©µÄµ±Ç°Ç÷ÊƼ°ÆäδÀ´·¢Õ¹¡£Ñݽ²Õß·ÖÏíÁËÈçºÎÀûÓò¹±è±è´´ÔìÉÌÒµ»ú»á£¬²¢·ÖÎöÁ˲¹±è±è¶Ô¸öÈËÉú»îºÍ¸÷ÐÐÒµµÄÓ°Ïì¡£Ô¤¼Æ²¹±è±è½«ÔÚÖÇÄܼҾӡ¢¹«Ë¾Ð§ÄÜÌáÉýºÍÊý×ÖÄÚÈݵÈÁìÓò·¢»ÓÔ½·¢ÖØÒªµÄ×÷Óá£Restructuring Capabilities
Restructuring CapabilitiesMWWPR
?
The MWW Group white paper outlines the complexities of restructuring, whether through court or outside Chapter 11, highlighting the importance of effective communication with key stakeholders. With over 80 years of experience in notable restructuring cases, MWW offers comprehensive communication strategies tailored to specific situations, leveraging their expertise in various areas including media relations and crisis management. They emphasize collaboration with clients, legal, and financial advisors to achieve successful restructuring outcomes.Micronutrientes
Micronutrientesnutriscience
?
The document discusses vitamin D and minerals. It provides the following key information:
1) The human body is composed primarily of oxygen, hydrogen, nitrogen, carbon, calcium, phosphorus, potassium, sulfur, sodium, chlorine, and magnesium. Vitamins and other micronutrients make up only 0.1% of the body.
2) Important sources of nutrients include oxygen and hydrogen from air and water, carbon as the basic structure of all foods, nitrogen from proteins, and minerals distributed across various foods.
3) Vitamins are divided into water-soluble vitamins like B vitamins and vitamin C, and fat-soluble vitamins like vitamins A, D, E, and K.Dtoan ct. nosco
Dtoan ct. noscoHo¨¤ng Gia
?
T¨¤i li?u chi ti?t v? c¨¢c c?ng tr¨¬nh v¨¤ d? ¨¢n li¨ºn quan ??n k? thu?t x?y d?ng, bao g?m c¨¢c kho?n chi ph¨ª v¨¤ gi¨¢ tr? t¨¤i s?n. N¨® ?? c?p ??n vi?c s? d?ng c¨¢c s? li?u v¨¤ ph?n t¨ªch ?? x¨¢c ??nh gi¨¢ tr? c?a c¨¢c d? ¨¢n x?y d?ng kh¨¢c nhau. N?i dung c?ng bao g?m c¨¢c kho?n chi ph¨ª c? th? cho t?ng lo?i c?ng tr¨¬nh v¨¤ y¨ºu c?u k? thu?t li¨ºn quan.Cell division-mitosis-meiosis-1225581257073362-9[1]
Cell division-mitosis-meiosis-1225581257073362-9[1]Feriha Ercan
?
Cell division occurs through two main processes - mitosis and meiosis. Mitosis produces two identical daughter cells during regular cell growth and reproduction. It has four phases: prophase, metaphase, anaphase and telophase. Meiosis produces gamete cells like eggs and sperm, which have half the normal number of chromosomes to ensure fertility. During meiosis, one cell undergoes two cell divisions to produce four daughter cells each with half the original number of chromosomes. This allows for genetic variation in offspring. Cell division is essential for growth, repair and reproduction of living organisms.Mars odurtspp
Mars odurtsppmajarlie24
?
This document provides an overview of 4-H programming at various centers in Virginia, including the roles and responsibilities of a Program Director. It discusses managing camp programs, staff, budgets, and partnerships. Professional development opportunities are also outlined, as well as ways for individuals to get involved with 4-H as volunteers, interns, or staff. Realities of working in the field such as the need for experience, connections, passion, and diverse skills are also addressed.The uk
The uksusana ferreras
?
The document provides an overview of the United Kingdom and its constituent nations. It describes the UK as a constitutional monarchy located in Western Europe with London as its capital city. Key details are given about England, Wales, Scotland, and Northern Ireland, including their capital cities, flags, famous landmarks, and symbols.Simple machines makayla and jahneia
Simple machines makayla and jahneiasmbass62
?
The document describes various simple machines and their uses. It explains that inclined planes like stairs and slides help get to higher places, wedges like doorstops help stop doors from moving, screws hold things together, levers allow easier opening of jar lids, pulleys are used to lower things, wheels and axles make things move, compound machines like scissors use two or more simple machines to perform tasks, and staplers are an example of a compound machine that uses a wedge.Postgresql security
Postgresql securityTechMaster Vietnam
?
T¨¤i li?u cung c?p h??ng d?n v? vi?c qu?n l? b?o m?t trong PostgreSQL, nh?n m?nh t?m quan tr?ng c?a vi?c ph?n quy?n v¨¤ s? d?ng c¨¢c role kh¨¢c nhau cho ?ng d?ng. S? d?ng role 'db_admin' v¨¤ 'db_user' ?? qu?n l? quy?n truy c?p v¨¤ h?n ch? thay ??i d? li?u, v?i c¨¢c kh¨¢i ni?m nh? Row Level Security ?? b?o v? d? li?u nh?y c?m. Ngo¨¤i ra, t¨¤i li?u h??ng d?n c¨¢ch s? d?ng c¨¢c l?nh grant v¨¤ revoke ?? ki?m so¨¢t quy?n truy c?p cho c¨¢c role c? th?.3. phan quyen trong sql server 01012010
3. phan quyen trong sql server 01012010Truong van Duoc
?
T¨¤i li?u n¨¤y tr¨¬nh b¨¤y v? ph?n quy?n trong SQL Server, bao g?m kh¨¢i ni?m v? ng??i ??ng nh?p, ng??i d¨´ng, quy?n h?n v¨¤ nh¨®m quy?n. N¨® h??ng d?n c¨¢ch t?o, x¨®a v¨¤ qu?n l? ng??i d¨´ng v¨¤ quy?n h?n th?ng qua c¨¢c l?nh SQL. C¨¢c v¨ª d? c? th? minh h?a c¨¢ch c?p v¨¤ thu h?i quy?n cho ng??i d¨´ng v¨¤ nh¨®m quy?n.ºÝºÝߣ 1.pdf
ºÝºÝߣ 1.pdfPHAMTHAOVY
?
T¨¤i li?u cung c?p th?ng tin v? qu?n tr? v¨¤ ph?n quy?n ng??i d¨´ng trong SQL Server, bao g?m quy?n ??ng nh?p, quy?n truy xu?t d? li?u v¨¤ c¨¢ch t?o v¨¤ qu?n l? t¨¤i kho?n ??ng nh?p. N¨® m? t? c¨¢c ch? ?? b?o m?t, quy?n truy c?p server-wide v¨¤ c¨¢c role trong c? s? d? li?u. C¨¢c ph??ng ph¨¢p s? d?ng SSMS v¨¤ Transact-SQL ?? t?o v¨¤ ?i?u ch?nh c¨¢c t¨¤i kho?n v¨¤ quy?n truy c?p c?ng ???c ?? c?p ??n.Database Schema and Relationships abcxyz
Database Schema and Relationships abcxyzd0512203hhd
?
T¨¤i li?u m? t? c?u tr¨²c c? s? d? li?u v?i ba b?ng ch¨ªnh: roles, info, v¨¤ accounts. B?ng roles l?u tr? th?ng tin v? vai tr¨° ng??i d¨´ng, b?ng info ch?a th?ng tin c¨¢ nh?n, v¨¤ b?ng accounts qu?n l? t¨¤i kho?n v?i th?ng tin ??ng nh?p v¨¤ li¨ºn k?t t?i vai tr¨° v¨¤ th?ng tin c¨¢ nh?n. M?i b?ng ??u c¨® c¨¢c kh¨®a ch¨ªnh v¨¤ c¨¢c r¨¤ng bu?c li¨ºn k?t gi?a c¨¢c b?ng.ºÝºÝߣ create databases_linh
ºÝºÝߣ create databases_linhkhacthuong2008
?
T¨¤i li?u h??ng d?n c¨¢ch t?o c? s? d? li?u trong PostgreSQL bao g?m c¨¢c b??c t?o database, table, column, kh¨®a ch¨ªnh v¨¤ kh¨®a ngo?i. Ng??i d¨´ng ???c h??ng d?n t?ng b??c t? vi?c c¨¤i ??t pgAdmin, ch?n th?ng s? cho database, table v¨¤ column, ??n vi?c ch¨¨n d? li?u v¨¤o c¨¢c table ?? t?o. Cu?i c¨´ng, t¨¤i li?u c?ng ?? c?p ??n c¨¢c quy?n v¨¤ c?u h¨¬nh cho c? s? d? li?u v¨¤ c¨¢c ??i t??ng trong b?ng.More Related Content
Viewers also liked (17)
Photoshoot ppt for blog
Photoshoot ppt for blogjessiekeegan
?
The document discusses selecting a background and photo for a magazine cover. Several background options were tested, including a red brick wall, concrete, and plain white, but most did not work well. A photo with a model against a brick wall was chosen as the final image because the colors and linear brick pattern provide guidance for text while still standing out clearly. The model's expression of confusion also fits the desired mood.Convocatoria Concurso de Prototipos 2013CBTIS No. 48
?
Convocatoria del proceso para concurso de prototiposEl P¨¨sol Negre. N¨²mero 1. Mar? 2008 (1a ¨¨poca)
El P¨¨sol Negre. N¨²mero 1. Mar? 2008 (1a ¨¨poca)Cgtmanresa Bages
?
El P¨¨sol Negre. N¨²mero 1. Mar? 2008Email
EmailQudsi Falkhi
?
Dokumen ini membahas tentang pengertian email dan sistem kerjanya. Email merupakan fasilitas surat elektronik melalui internet yang pertama kali dikembangkan oleh Ray Tomlinson pada tahun 1971 dengan menggunakan tanda ¡°@¡± untuk memisahkan user ID dan domain pada alamat email. Ada beberapa jenis email seperti POP mail yang menyimpan email secara offline, web-based mail yang dapat diakses dimana saja melalui internet, dan email forwarding yang meneruskan email keContinental philosophy
Continental philosophytjmartin72768
?
This document provides an overview of analytic vs continental philosophy, highlighting their differing views on the role of science and emphasis on history/context. It then summarizes several articles and ideas within continental philosophy, including:
1) Richard Rorty linking American pragmatism with hermeneutics and arguing they both reject Platonic absolutism in favor of tradition-bound truths.
2) Nietzsche's criticism of Platonic reason and objectivity, arguing truth is contextual and interpretation-based.
3) Hermeneutics and social constructivism viewing truth as emerging from and conditioned by language, culture, and social structures.
4) Both strengths and challenges of the hermFirst British Settlers
First British SettlersCyntia Oca?as
?
The document outlines several major events and social changes in British history from the earliest settlers through the 20th century:
1) Celtic tribes arrived in Britain in the 5th century BCE and established societies led by kings with Druids serving important religious roles. The Romans then invaded in 43 CE and controlled much of the island.
2) Anglo-Saxons invaded beginning in the 5th century CE and established several kingdoms that were eventually united under King Alfred. Vikings then raided parts of Britain beginning in 793 CE.
3) The Norman invasion in 1066 CE introduced feudalism and manorialism. Over subsequent centuries, events like the Industrial Revolution, world wars, and reform acts broad½â¶Á´¡±è±èÐÂÇ÷ÊÆ£¬ÔËÓô¡±è±èÓ®µÃ¸ü¶àÉÌ»ú£¡
½â¶Á´¡±è±èÐÂÇ÷ÊÆ£¬ÔËÓô¡±è±èÓ®µÃ¸ü¶àÉÌ»ú£¡Leo Lin
?
±¾ÎļþÌÖÂÛÁËÓ¦ÓóÌÐò£¨²¹±è±è£©µÄµ±Ç°Ç÷ÊƼ°ÆäδÀ´·¢Õ¹¡£Ñݽ²Õß·ÖÏíÁËÈçºÎÀûÓò¹±è±è´´ÔìÉÌÒµ»ú»á£¬²¢·ÖÎöÁ˲¹±è±è¶Ô¸öÈËÉú»îºÍ¸÷ÐÐÒµµÄÓ°Ïì¡£Ô¤¼Æ²¹±è±è½«ÔÚÖÇÄܼҾӡ¢¹«Ë¾Ð§ÄÜÌáÉýºÍÊý×ÖÄÚÈݵÈÁìÓò·¢»ÓÔ½·¢ÖØÒªµÄ×÷Óá£Restructuring Capabilities
Restructuring CapabilitiesMWWPR
?
The MWW Group white paper outlines the complexities of restructuring, whether through court or outside Chapter 11, highlighting the importance of effective communication with key stakeholders. With over 80 years of experience in notable restructuring cases, MWW offers comprehensive communication strategies tailored to specific situations, leveraging their expertise in various areas including media relations and crisis management. They emphasize collaboration with clients, legal, and financial advisors to achieve successful restructuring outcomes.Micronutrientes
Micronutrientesnutriscience
?
The document discusses vitamin D and minerals. It provides the following key information:
1) The human body is composed primarily of oxygen, hydrogen, nitrogen, carbon, calcium, phosphorus, potassium, sulfur, sodium, chlorine, and magnesium. Vitamins and other micronutrients make up only 0.1% of the body.
2) Important sources of nutrients include oxygen and hydrogen from air and water, carbon as the basic structure of all foods, nitrogen from proteins, and minerals distributed across various foods.
3) Vitamins are divided into water-soluble vitamins like B vitamins and vitamin C, and fat-soluble vitamins like vitamins A, D, E, and K.Dtoan ct. nosco
Dtoan ct. noscoHo¨¤ng Gia
?
T¨¤i li?u chi ti?t v? c¨¢c c?ng tr¨¬nh v¨¤ d? ¨¢n li¨ºn quan ??n k? thu?t x?y d?ng, bao g?m c¨¢c kho?n chi ph¨ª v¨¤ gi¨¢ tr? t¨¤i s?n. N¨® ?? c?p ??n vi?c s? d?ng c¨¢c s? li?u v¨¤ ph?n t¨ªch ?? x¨¢c ??nh gi¨¢ tr? c?a c¨¢c d? ¨¢n x?y d?ng kh¨¢c nhau. N?i dung c?ng bao g?m c¨¢c kho?n chi ph¨ª c? th? cho t?ng lo?i c?ng tr¨¬nh v¨¤ y¨ºu c?u k? thu?t li¨ºn quan.Cell division-mitosis-meiosis-1225581257073362-9[1]
Cell division-mitosis-meiosis-1225581257073362-9[1]Feriha Ercan
?
Cell division occurs through two main processes - mitosis and meiosis. Mitosis produces two identical daughter cells during regular cell growth and reproduction. It has four phases: prophase, metaphase, anaphase and telophase. Meiosis produces gamete cells like eggs and sperm, which have half the normal number of chromosomes to ensure fertility. During meiosis, one cell undergoes two cell divisions to produce four daughter cells each with half the original number of chromosomes. This allows for genetic variation in offspring. Cell division is essential for growth, repair and reproduction of living organisms.Mars odurtspp
Mars odurtsppmajarlie24
?
This document provides an overview of 4-H programming at various centers in Virginia, including the roles and responsibilities of a Program Director. It discusses managing camp programs, staff, budgets, and partnerships. Professional development opportunities are also outlined, as well as ways for individuals to get involved with 4-H as volunteers, interns, or staff. Realities of working in the field such as the need for experience, connections, passion, and diverse skills are also addressed.The uk
The uksusana ferreras
?
The document provides an overview of the United Kingdom and its constituent nations. It describes the UK as a constitutional monarchy located in Western Europe with London as its capital city. Key details are given about England, Wales, Scotland, and Northern Ireland, including their capital cities, flags, famous landmarks, and symbols.Simple machines makayla and jahneia
Simple machines makayla and jahneiasmbass62
?
The document describes various simple machines and their uses. It explains that inclined planes like stairs and slides help get to higher places, wedges like doorstops help stop doors from moving, screws hold things together, levers allow easier opening of jar lids, pulleys are used to lower things, wheels and axles make things move, compound machines like scissors use two or more simple machines to perform tasks, and staplers are an example of a compound machine that uses a wedge.Similar to Role (20)
Postgresql security
Postgresql securityTechMaster Vietnam
?
T¨¤i li?u cung c?p h??ng d?n v? vi?c qu?n l? b?o m?t trong PostgreSQL, nh?n m?nh t?m quan tr?ng c?a vi?c ph?n quy?n v¨¤ s? d?ng c¨¢c role kh¨¢c nhau cho ?ng d?ng. S? d?ng role 'db_admin' v¨¤ 'db_user' ?? qu?n l? quy?n truy c?p v¨¤ h?n ch? thay ??i d? li?u, v?i c¨¢c kh¨¢i ni?m nh? Row Level Security ?? b?o v? d? li?u nh?y c?m. Ngo¨¤i ra, t¨¤i li?u h??ng d?n c¨¢ch s? d?ng c¨¢c l?nh grant v¨¤ revoke ?? ki?m so¨¢t quy?n truy c?p cho c¨¢c role c? th?.3. phan quyen trong sql server 01012010
3. phan quyen trong sql server 01012010Truong van Duoc
?
T¨¤i li?u n¨¤y tr¨¬nh b¨¤y v? ph?n quy?n trong SQL Server, bao g?m kh¨¢i ni?m v? ng??i ??ng nh?p, ng??i d¨´ng, quy?n h?n v¨¤ nh¨®m quy?n. N¨® h??ng d?n c¨¢ch t?o, x¨®a v¨¤ qu?n l? ng??i d¨´ng v¨¤ quy?n h?n th?ng qua c¨¢c l?nh SQL. C¨¢c v¨ª d? c? th? minh h?a c¨¢ch c?p v¨¤ thu h?i quy?n cho ng??i d¨´ng v¨¤ nh¨®m quy?n.ºÝºÝߣ 1.pdf
ºÝºÝߣ 1.pdfPHAMTHAOVY
?
T¨¤i li?u cung c?p th?ng tin v? qu?n tr? v¨¤ ph?n quy?n ng??i d¨´ng trong SQL Server, bao g?m quy?n ??ng nh?p, quy?n truy xu?t d? li?u v¨¤ c¨¢ch t?o v¨¤ qu?n l? t¨¤i kho?n ??ng nh?p. N¨® m? t? c¨¢c ch? ?? b?o m?t, quy?n truy c?p server-wide v¨¤ c¨¢c role trong c? s? d? li?u. C¨¢c ph??ng ph¨¢p s? d?ng SSMS v¨¤ Transact-SQL ?? t?o v¨¤ ?i?u ch?nh c¨¢c t¨¤i kho?n v¨¤ quy?n truy c?p c?ng ???c ?? c?p ??n.Database Schema and Relationships abcxyz
Database Schema and Relationships abcxyzd0512203hhd
?
T¨¤i li?u m? t? c?u tr¨²c c? s? d? li?u v?i ba b?ng ch¨ªnh: roles, info, v¨¤ accounts. B?ng roles l?u tr? th?ng tin v? vai tr¨° ng??i d¨´ng, b?ng info ch?a th?ng tin c¨¢ nh?n, v¨¤ b?ng accounts qu?n l? t¨¤i kho?n v?i th?ng tin ??ng nh?p v¨¤ li¨ºn k?t t?i vai tr¨° v¨¤ th?ng tin c¨¢ nh?n. M?i b?ng ??u c¨® c¨¢c kh¨®a ch¨ªnh v¨¤ c¨¢c r¨¤ng bu?c li¨ºn k?t gi?a c¨¢c b?ng.ºÝºÝߣ create databases_linh
ºÝºÝߣ create databases_linhkhacthuong2008
?
T¨¤i li?u h??ng d?n c¨¢ch t?o c? s? d? li?u trong PostgreSQL bao g?m c¨¢c b??c t?o database, table, column, kh¨®a ch¨ªnh v¨¤ kh¨®a ngo?i. Ng??i d¨´ng ???c h??ng d?n t?ng b??c t? vi?c c¨¤i ??t pgAdmin, ch?n th?ng s? cho database, table v¨¤ column, ??n vi?c ch¨¨n d? li?u v¨¤o c¨¢c table ?? t?o. Cu?i c¨´ng, t¨¤i li?u c?ng ?? c?p ??n c¨¢c quy?n v¨¤ c?u h¨¬nh cho c? s? d? li?u v¨¤ c¨¢c ??i t??ng trong b?ng.Lecture5 userandgroup c¨® ghi ch¨²
Lecture5 userandgroup c¨® ghi ch¨²L? ??t
?
T¨¤i li?u cung c?p h??ng d?n v? qu?n l? t¨¤i kho?n ng??i d¨´ng v¨¤ nh¨®m trong m?i tr??ng workgroup v¨¤ domain, bao g?m vi?c t?o, ch?nh s?a, v¨¤ x¨¢c th?c c¨¢c t¨¤i kho?n ng??i d¨´ng c?ng nh? c¨¢c nh¨®m. N¨® gi?i th¨ªch c¨¢ch ph?n quy?n truy c?p t¨¤i nguy¨ºn qua c¨¢c lo?i nh¨®m kh¨¢c nhau nh? security groups v¨¤ distribution groups, c¨´ng v?i c¨¢c c?ng c? d¨°ng l?nh ?? qu?n l? t¨¤i kho?n. Cu?i c¨´ng, t¨¤i li?u ?? c?p ??n c¨¢c ch¨ªnh s¨¢ch qu?n l? t¨¤i kho?n nh?m b?o v? v¨¤ t?i ?u h¨®a quy?n truy c?p.Mcsa 2012 domain network thu?c t¨ªnh user v¨¤ group
Mcsa 2012 domain network thu?c t¨ªnh user v¨¤ grouplaonap166
?
T¨¤i li?u tr¨¬nh b¨¤y v? c¨¢c thu?c t¨ªnh c?a ng??i d¨´ng, nh¨®m v¨¤ c¨¢ch ?y quy?n trong Active Directory trong m?i tr??ng MCSA 2012, bao g?m c¨¢c c?u h¨¬nh c? b?n v¨¤ qu?n l? nh¨®m hi?u qu?. N¨® m? t? c¨¢c thu?c t¨ªnh c?a ng??i d¨´ng nh? gi? ??ng nh?p v¨¤ quy?n h?n, c?ng nh? c¨¢ch t?o v¨¤ qu?n l? nh¨®m v?i c¨¢c lo?i nh? security v¨¤ distribution. Cu?i c¨´ng, t¨¤i li?u h??ng d?n c¨¢ch s? d?ng Organizational Units (OU) ?? t? ch?c v¨¤ qu?n l? quy?n h?n trong h? th?ng l?n.ºÝºÝߣ m?n ??m b?o an to¨¤n th?ng tin
ºÝºÝߣ m?n ??m b?o an to¨¤n th?ng tinducmanhkthd
?
T¨¤i li?u b¨¤n v? b?o m?t c? s? d? li?u, g?m c¨¢c c? ch? b?o m?t nh? ?y quy?n v¨¤ thu h?i quy?n truy c?p, m? h¨®a d? li?u, v¨¤ c¨¢c ph??ng ph¨¢p qu?n l? b?o m?t h? qu?n tr? c? s? d? li?u. N¨® ?? c?p ??n c¨¢c v?n ?? nh? SQL injection v¨¤ t?n c?ng m?ng, c¨´ng v?i vi?c s? d?ng c¨¢c h¨¤m b?m nh? MD5 ?? b?o v? d? li?u. B¨¤i vi?t c?ng ph?n t¨ªch c¨¢c m? h¨¬nh b?o m?t v¨¤ khuy?n ngh? thi?t k? an to¨¤n nh?m b?o v? d? li?u kh?i c¨¢c m?i ?e d?a.Gpo
Gpoit
?
T¨¤i li?u cung c?p c¨¢i nh¨¬n t?ng quan v? ng??i d¨´ng v¨¤ quy?n h?n trong m?ng l??i m¨¢y t¨ªnh, v?i c¨¢c kh¨¢i ni?m ch¨ªnh nh? t¨¤i kho?n ng??i d¨´ng c?c b? v¨¤ mi?n, nh¨®m ng??i d¨´ng, v¨¤ ??n v? t? ch?c (OU). N¨® c?ng m? t? c¨¢ch m¨¤ ch¨ªnh s¨¢ch nh¨®m (Group Policy) ???c s? d?ng ?? qu?n l? quy?n truy c?p v¨¤ qu?n tr? ng??i d¨´ng, c?ng nh? c¨¢c ph??ng ph¨¢p ?? gi?i quy?t v?n ?? li¨ºn quan ??n ch¨ªnh s¨¢ch nh¨®m. Cu?i c¨´ng, t¨¤i li?u nh?n m?nh t?m quan tr?ng c?a vi?c t? ch?c v¨¤ ¨¢p d?ng hi?u qu? c¨¢c ch¨ªnh s¨¢ch nh¨®m trong m?i tr??ng doanh nghi?p.Authentication and Authorization
Authentication and AuthorizationTechMaster Vietnam
?
T¨¤i li?u tr¨¬nh b¨¤y c¨¢c kh¨¢i ni?m v? ph?n quy?n v¨¤ x¨¢c th?c trong ?ng d?ng, bao g?m vi?c s? d?ng JWT, session/cookie, v¨¤ OAuth 2. N¨® c?ng ?? xu?t c¨¢c c¨¢ch qu?n l? quy?n truy c?p ng??i d¨´ng th?ng qua enum v¨¤ c? s? d? li?u, ??ng th?i ??a ra so s¨¢nh gi?a JWT v¨¤ c¨¢c ph??ng th?c x¨¢c th?c kh¨¢c. Cu?i c¨´ng, t¨¤i li?u h??ng d?n quy tr¨¬nh x¨¢c th?c v¨¤ c?p token cho ng??i d¨´ng trong ?ng d?ng.ORACLE_ch2_SQL.pptx
ORACLE_ch2_SQL.pptxQuangTrnMinh18
?
T¨¤i li?u tr¨¬nh b¨¤y ng?n ng? SQL, bao g?m c¨¢c kh¨¢i ni?m, ph?n lo?i v¨¤ c¨² ph¨¢p cho c¨¢c l?nh nh? t?o, s?a, x¨®a b?ng, view, c?ng nh? c¨¢c thao t¨¢c v?i d? li?u. N¨® ?? c?p ??n c¨¢c lo?i d? li?u, c?u tr¨²c b?ng trong c? s? d? li?u v¨¤ c¨¢c l?nh SQL c? b?n nh? insert, update, delete, v¨¤ select. Ngo¨¤i ra, t¨¤i li?u c?ng cung c?p c¨¢c v¨ª d? th?c t? ?? minh h?a c¨¢ch s? d?ng c¨¢c l?nh SQL trong qu?n l? th?ng tin trong c? s? d? li?u.Chuyen De 1 CSDL nang cao
Chuyen De 1 CSDL nang caoHo¨¤ng Ch¨ª D?ng
?
T¨¤i li?u tr¨¬nh b¨¤y v? c? s? d? li?u h??ng ??i t??ng, bao g?m l? thuy?t v? m? h¨¬nh d? li?u v¨¤ c¨¢c kh¨¢i ni?m nh? ??nh danh ??i t??ng, k? th?a, v¨¤ giao di?n c? s? d? li?u. N¨® c?ng th?o lu?n v? s? ph¨¢t tri?n c?a c¨¢c h? th?ng c? s? d? li?u trong nh?ng n?m 1980 v¨¤ c¨¢c ng?n ng? truy v?n nh? Object Query Language. Cu?i c¨´ng, t¨¤i li?u n¨ºu ra nh?ng th¨¢ch th?c v¨¤ tranh lu?n xung quanh t??ng lai c?a c? s? d? li?u quan h? v¨¤ h??ng ??i t??ng.Bai10 he thong bao ve bao mat
Bai10 he thong bao ve bao matV? Sang
?
T¨¤i li?u th?o lu?n v? c¨¢c h¨¬nh th?c t?n c?ng h? th?ng m¨¢y t¨ªnh v¨¤ c¨¢c c? ch? b?o v? b?o m?t c?a h? ?i?u h¨¤nh, bao g?m c? Windows NT. N¨® ?? c?p ??n c¨¢c m?i ?e d?a ??i v?i t¨ªnh ri¨ºng t?, t¨ªnh to¨¤n v?n v¨¤ t¨ªnh s?n s¨¤ng, c¨´ng v?i c¨¢c ph??ng ph¨¢p t?n c?ng t? trong v¨¤ ngo¨¤i h? th?ng. B¨ºn c?nh ?¨®, t¨¤i li?u tr¨¬nh b¨¤y c¨¢c c? ch? ch?ng th?c, m? h¨®a, ?i?u khi?n truy c?p v¨¤ ch¨ªnh s¨¢ch b?o m?t trong qu?n l? h? th?ng.Chuong 3 ER
Chuong 3 ERQuangHuy668560
?
Ch??ng 3 c?a t¨¤i li?u tr¨¬nh b¨¤y m? h¨¬nh d? li?u quan h? trong c? s? d? li?u, bao g?m c¨¢c kh¨¢i ni?m nh? quan h?, thu?c t¨ªnh, v¨¤ b?. N¨® c?ng gi?i thi?u v? c¨¢c lo?i kh¨®a, c¨¢c ??c tr?ng c?a m? h¨¬nh quan h? v¨¤ c¨¢ch chuy?n ??i l??c ?? E/R sang thi?t k? quan h?. Cu?i c¨´ng, ch??ng gi?i th¨ªch c¨¢c th¨¤nh ph?n c? b?n v¨¤ quy t?c trong l??c ?? quan h?.B¨¤i gi?ng c? s? d? li?u M? h¨¬nh th?c th? k?t h?p
B¨¤i gi?ng c? s? d? li?u M? h¨¬nh th?c th? k?t h?pL¨º Ph¨² Th?o
?
Ch??ng 2 tr¨¬nh b¨¤y m? h¨¬nh th?c th?-k?t h?p (E/R) trong thi?t k? c? s? d? li?u, bao g?m c¨¢c kh¨¢i ni?m nh? th?c th?, thu?c t¨ªnh, m?i quan h? v¨¤ l??c ?? E/R. N¨® c?ng m? t? quy tr¨¬nh thi?t k? c? s? d? li?u t? ph?n t¨ªch y¨ºu c?u ??n thi?t k? l??c ?? v?t l?. V¨ª d? ???c ??a ra v? qu?n l? ?? ¨¢n c?ng ty cho th?y ?ng d?ng c?a m? h¨¬nh E/R trong th?c ti?n.H? qu?n tr? CSDL PostgreSQL cho sinh vi¨ºn
H? qu?n tr? CSDL PostgreSQL cho sinh vi¨ºnTranHoangViet001455
?
PostgreSQL l¨¤ h? qu?n tr? c? s? d? li?u quan h? m? ngu?n m?, ph¨¢t tri?n t? n?m 1986, v?i phi¨ºn b?n hi?n t?i l¨¤ 13. N¨® h? tr? ??y ?? c¨¢c t¨ªnh n?ng quan tr?ng nh? ki?m so¨¢t ??ng th?i, sao l?u v¨¤ ph?c h?i, c?ng nh? h? tr? cho nhi?u lo?i d? li?u nh? JSON v¨¤ d? li?u ??a l?. PostgreSQL ph¨´ h?p v?i nh?ng ?ng d?ng c?n t¨ªnh to¨¤n v?n d? li?u v¨¤ kh? n?ng t¨´y ch?nh cao, m?c d¨´ c¨® th? kh?ng ph?i l¨¤ l?a ch?n t?t nh?t cho hi?u su?t ??c nhanh.C2 1
C2 1Tr?n Thanh
?
M? h¨¬nh th?c th? - li¨ºn k?t (ER) l¨¤ m?t ph??ng ph¨¢p thi?t k? cho c? s? d? li?u, s? d?ng c¨¢c kh¨¢i ni?m v? th?c th?, thu?c t¨ªnh v¨¤ c¨¢c m?i quan h?. T¨¤i li?u ?? c?p ??n qu¨¢ tr¨¬nh thi?t k? c? s? d? li?u ? m?c quan ni?m v¨¤ c¨¢c b??c x?y d?ng l??c ?? ER. N?i dung c?ng bao g?m c¨¢c lo?i thu?c t¨ªnh, m?i quan h?, v¨¤ c¨¢c r¨¤ng bu?c trong thi?t k? c? s? d? li?u.Giaotrinh csdl
Giaotrinh csdlJohn Phan
?
T¨¤i li?u ch?a th?ng tin v? c¨¢c m? h¨¬nh quan h? trong c? s? d? li?u, ph??ng ph¨¢p to¨¢n t?p h?p v¨¤ truy v?n SQL. N¨® c?ng cung c?p ??nh ngh?a v¨¤ vai tr¨° c?a c? s? d? li?u c¨´ng v?i c¨¢c h? th?ng qu?n tr? c? s? d? li?u. C¨¢c n?i dung kh¨¢c bao g?m c¨¢ch th?c thi?t k? c? s? d? li?u v¨¤ c¨¢c b¨¤i t?p th?c h¨¤nh ?? kh?c s?u ki?n th?c.Giaotrinh csdl
Giaotrinh csdlT? v?n m?i tr??ng
?
T¨¤i li?u cung c?p c¨¢i nh¨¬n t?ng quan v? c? s? d? li?u (CSDL) v¨¤ h? qu?n tr? c? s? d? li?u (HQTCSQL), gi?i th¨ªch c¨¢c kh¨¢i ni?m v¨¤ m? h¨¬nh li¨ºn quan. N¨® bao g?m n?i dung v? c¨¢c m? h¨¬nh quan h?, ng?n ng? truy v?n SQL, v¨¤ c¨¢c kh¨¢i ni?m li¨ºn quan ??n ph?m vi, qu?n l? v¨¤ b?o tr¨¬ d? li?u. T¨¤i li?u c?ng tr¨¬nh b¨¤y c¨¢c b¨¤i t?p v¨¤ tr??ng h?p ?ng d?ng th?c t? ?? c?ng c? ki?n th?c.Giaotrinh csdl[bookbooming.com]
Giaotrinh csdl[bookbooming.com]bookbooming1
?
T¨¤i li?u tr¨¬nh b¨¤y v? m? h¨¬nh quan h? trong c? s? d? li?u, ??nh ngh?a c? s? d? li?u v¨¤ h? qu?n tr? c? s? d? li?u (HQT CSDL), ??ng th?i m? t? vai tr¨° quan tr?ng c?a ch¨²ng trong vi?c x? l? th?ng tin. Ngo¨¤i ra, t¨¤i li?u c?ng ?? c?p ??n c¨¢c kh¨¢i ni?m li¨ºn quan nh? ng??i d¨´ng, c¨¢c ph¨¦p to¨¢n h?p v¨¤ c¨¢c b¨¤i t?p th?c h¨¤nh ¨¢p d?ng. T¨¤i li?u c¨® nhi?u ch??ng chi ti?t v? c¨¢ch th?c thi?t k? v¨¤ qu?n l? c? s? d? li?u.Ad
More from khacthuong2008 (11)
Phan1
Phan1khacthuong2008
?
C? s? d? li?u (CSDL) l¨¤ h? th?ng th?ng tin c¨® c?u tr¨²c l?u tr? tr¨ºn thi?t b? ?? ph?c v? nhu c?u khai th¨¢c c?a ng??i s? d?ng. CSDL gi¨²p gi?m tr¨´ng l?p th?ng tin, truy xu?t d? li?u d? d¨¤ng, v¨¤ chia s? th?ng tin. H? qu?n tr? CSDL cung c?p c¨¢c ch??ng tr¨¬nh ?? qu?n l? truy xu?t d? li?u v¨¤ ??m b?o t¨ªnh b?o m?t v¨¤ an to¨¤n d? li?u.Phan2
Phan2khacthuong2008
?
??i s? quan h? gi?i thi?u c¨¢c ph¨¦p to¨¢n c? b?n trong truy v?n c? s? d? li?u nh? h?p, giao, t¨ªch ??-c¨¢c, hi?u v¨¤ chi?u. C¨¢c ph¨¦p to¨¢n n¨¤y ???c ¨¢p d?ng tr¨ºn c¨¢c quan h? ?? t?o ra c¨¢c k?t qu? m?i c?ng nh? t?i ?u h¨®a truy v?n. T¨¤i li?u c?ng cung c?p v¨ª d? c? th? cho t?ng ph¨¦p to¨¢n ?? minh h?a c¨¢ch th?c ho?t ??ng c?a ch¨²ng.Phan3
Phan3khacthuong2008
?
T¨¤i li?u cung c?p th?ng tin chi ti?t v? ng?n ng? truy v?n SQL, bao g?m c¨¢c thao t¨¢c c? b?n nh? t?o, s?a, x¨®a c? s? d? li?u v¨¤ b?ng, c?ng nh? truy v?n d? li?u t? c¨¢c b?ng. N¨® c¨°n gi?i th¨ªch c¨² ph¨¢p c?a nhi?u l?nh SQL quan tr?ng, ch?ng h?n nh? l?nh t?o kh¨®a ch¨ªnh, kh¨®a ngo?i, r¨¤ng bu?c d? li?u, v¨¤ c¨¢c c?u l?nh truy v?n v?i c¨¢c ?i?u ki?n kh¨¢c nhau. ??y l¨¤ t¨¤i li?u h?u ¨ªch cho nh?ng ai mu?n t¨¬m hi?u ho?c n?ng cao ki?n th?c v? SQL.Phan4
Phan4khacthuong2008
?
R¨¤ng bu?c to¨¤n v?n (Rbtv) l¨¤ quy t?c ??m b?o t¨ªnh nh?t qu¨¢n c?a d? li?u trong c? s? d? li?u v¨¤ ???c x¨¢c ??nh b?ng thu?t to¨¢n b¨ºn trong. Rbtv c¨® th? li¨ºn quan ??n nhi?u m?i quan h? v¨¤ y¨ºu c?u ki?m tra t? ??ng khi th?c hi?n c¨¢c thao t¨¢c c?p nh?t d? li?u. C¨¢c y?u t? c?a Rbtv bao g?m ?i?u ki?n, b?i c?nh, t?m ?nh h??ng v¨¤ h¨¤nh ??ng x? l? khi vi ph?m.Phan5
Phan5khacthuong2008
?
T¨¤i li?u tr¨¬nh b¨¤y m?t c¨¢ch chi ti?t v? c¨¢c kh¨ªa c?nh quan tr?ng c?a ch? ??. N¨® cung c?p th?ng tin v¨¤ s? li?u th?ng k¨º ?¨¢ng tin c?y ?? h? tr? c¨¢c lu?n ?i?m. N?i dung ???c t? ch?c h?p l? v¨¤ d? ti?p c?n.Phan6
Phan6khacthuong2008
?
T¨¤i li?u tr¨¬nh b¨¤y v? quy tr¨¬nh chu?n h¨®a c? s? d? li?u (CSDL) v?i c¨¢c d?ng chu?n c? b?n nh? 1NF, 2NF, 3NF v¨¤ Boyce-Codd. M?i d?ng chu?n ??nh ngh?a t¨ªnh ch?t c?a c¨¢c thu?c t¨ªnh trong m?t l??c ?? quan h? v¨¤ nh?m tr¨¢nh sai s¨®t trong vi?c qu?n l? d? li?u. Ngo¨¤i ra, ph??ng ph¨¢p ph?n r? ???c ?? xu?t ?? n?ng cao ch?t l??ng thi?t k? CSDL v¨¤ ??m b?o b?o to¨¤n th?ng tin.Group 1 hao_nv
Group 1 hao_nvkhacthuong2008
?
T¨¤i li?u cung c?p m?t c¨¢i nh¨¬n t?ng quan v? PostgreSQL, h? qu?n tr? c? s? d? li?u m? ngu?n m?, h? tr? ?a ng?n ng? v¨¤ qu?n l? d? li?u l?n. N¨® m? t? c¨¢c c?ng c? GUI nh? pgAdmin v¨¤ h??ng d?n c¨¢ch th?c hi?n truy v?n, sao l?u v¨¤ ph?c h?i d? li?u. Ngo¨¤i ra, t¨¤i li?u c?ng n¨ºu r? c¨¢ch ph?n quy?n v¨¤ t?o c¨¢c c?u l?nh SQL ??n gi?n.Group 1 hao_nv
Group 1 hao_nvkhacthuong2008
?
PostgreSQL l¨¤ m?t h? qu?n tr? c? s? d? li?u m? ngu?n m?, h? tr? ?a ng?n ng? v¨¤ c¨® kh? n?ng qu?n l? d? li?u l¨ºn t?i terabyte v?i dung l??ng c? s? d? li?u kh?ng gi?i h?n. T¨¤i li?u ?? c?p ??n c?u tr¨²c, c?ng c? ?? h?a, v¨¤ quy tr¨¬nh truy v?n c? b?n trong PostgreSQL, bao g?m c¨¢ch t?o v¨¤ ch?y c¨¢c l?nh truy v?n. Ngo¨¤i ra, n¨® c?ng n¨ºu r? c¨¢c c?ng c? GUI nh? pgAdmin v¨¤ h??ng d?n s? d?ng ch¨²ng ?? th?c hi?n truy v?n hi?u qu?.Postgre sql nhunq
Postgre sql nhunqkhacthuong2008
?
T¨¤i li?u ?? c?p ??n quy tr¨¬nh backup v¨¤ restore trong PostgreSQL b?ng c¨¢ch s? d?ng c¨¢c l?nh nh? pg_dump, pg_dumpall v¨¤ pg_restore, c?ng nh? h??ng d?n s? d?ng pgAdmin III. N¨® cung c?p th?ng tin v? c¨¢ch th?c hi?n backup, restore v?i c¨¢c lo?i file kh¨¢c nhau v¨¤ c¨¢ch x? l? c¨¢c ??i t??ng trong database. Nh?ng l?u ? v? quy?n h?n c?a ng??i d¨´ng v¨¤ c¨¢c t¨´y ch?n backup c?ng ???c n¨ºu r?.Presentation
Presentationkhacthuong2008
?
T¨¤i li?u tr¨¬nh b¨¤y v? s? ?? c? s? d? li?u (database diagram) trong PostgreSQL, gi?i th¨ªch kh¨¢i ni?m v¨¤ c¨¢ch t?o s? ?? n¨¤y b?ng c?ng c? PostgreSQL Maestro. S? ?? m? t? c¨¢c b?ng d? li?u, thu?c t¨ªnh, kh¨®a v¨¤ m?i quan h? gi?a ch¨²ng, v?i c¨¢c v¨ª d? c? th? v¨¤ h??ng d?n s? d?ng c?ng c?. Ngo¨¤i ra, t¨¤i li?u n¨ºu r? c¨¢c ?u nh??c ?i?m c?a PostgreSQL Maestro trong vi?c t?o s? ??.Postgre Diagram
Postgre Diagramkhacthuong2008
?
T¨¤i li?u m? t? v? s? ?? c? s? d? li?u (database diagram) trong PostgreSQL, bao g?m c¨¢ch t?o v¨¤ c¨¢c c?ng c? h? tr? nh? PostgreSQL Maestro. S? ?? n¨¤y gi¨²p m? t? c¨¢c b?ng, thu?c t¨ªnh v¨¤ m?i quan h? gi?a ch¨²ng. T¨¤i li?u c?ng n¨ºu r? ?u nh??c ?i?m c?a PostgreSQL Maestro trong qu¨¢ tr¨¬nh t?o s? ?? c? s? d? li?u.Ad
Role
- 1. Postgresql www.elarion.com [email_address] Never stop improving quality
- 2. Presentation Template Role Database Roles Role Attributes Role Membership Function and Triggers
- 3. Database Roles L¨¤ m?t kh¨¢i ni?m ho¨¤n to¨¤n ??c l?p v?i t¨¤i kho?n ng??i d¨´ng c?a h? ??u h¨¤nh C¨² ph¨¢p t?o v¨¤ x¨®a Database Roles: CREATE ROLE name DROP ROLE name Presentation Template
- 4. Role Attributes (1/5) Database Role c¨® m?t s? thu?c t¨ªnh nh? sau : Login C¨² ph¨¢p : CREATE ROLE name LOGIN CREATE USER name Hai c¨² ph¨¢p tr¨ºn t??ng ???ng nhau nh?ng CREATE USER m?c ??nh l¨¤ c¨® thu?c t¨ªnh LOGIN cho n¨ºn kh?ng c?n khai b¨¢o n?a , c¨°n CREATE ROLE th¨¬ kh?ng v¨¬ v?y ph?i c?n khai b¨¢o th¨ºm thu?c t¨ªnh LOGIN
- 5. Role Attributes (2/5) Superuser C¨² ph¨¢p : CREATE ROLE name SUPERUSER ??y l¨¤ thu?c t¨ªnh cho ph¨¦p s? d?ng t?t c? c¨¢c ch?c n?ng trong Postgresql , thu?c t¨ªnh n¨¤y r?t nguy hi?m v¨¬ v?y n¨ºn s? d?ng m?t c¨¢ch c?n th?n khi ph?n quy?n ?? b?o m?t h?n th¨¬ n¨ºn th¨ºm thu?c t¨ªnh NOREPLICATION v¨¬ n?u kh?ng c¨® thu?c t¨ªnh n¨¤y th¨¬ t? ??ng s? c¨® m?t ch? ?? sao ch¨¦p quy?n c?a m?t Superuser c¨® s?n
- 6. Role Attributes (3/5) Create database objects C¨² ph¨¢p : CREATE ROLE name CREATEDB Thu?c t¨ªnh n¨¤y cho ph¨¦p role n¨¤y c¨® th? t?o , x¨®a , s?a database N?u l¨¤ Superuser th¨¬ kh?ng ph?i khai b¨¢o th??c t¨ªnh n¨¤y v¨¬ Superuser ?? bao g?m b¨ºn trong
- 7. Role Attributes (4/5) Create roles C¨² ph¨¢p : CREATE ROLE name CREATEROLE Thu?c t¨ªnh n¨¤y cho ph¨¦p t?o , x¨®a , s?a role c?ng nh? c?p quy?n ho?c thu h?i nh?ng th¨¤nh vi¨ºn c?a role ?¨® Thu?c t¨ªnh n¨¤y kh?ng ?? ?? th?c hi?n c¨¢c ch?c n?ng tr¨ºn ??i v?i Superuser
- 8. Role Attributes (5/5) Initiating streaming replication and backups C¨² ph¨¢p : CREATE ROLE name REPLICATION LOGIN Thu?c t¨ªnh n¨¤y cho ph¨¦p kh?i t?o m?t lu?ng sao ch¨¦p v¨¤ backup. Role n¨¤y lu?n lu?n c¨® thu?c t¨ªnh LOGIN Password C¨² ph¨¢p : CREATE ROLE name PASSWORD ¡® String¡¯ Cho ph¨¦p t?o role c¨® password v¨¤ ???c m? h¨®a md5
- 9. Role Membership (1/6) Role Membership gi¨²p qu?n l? c¨¢c Role m?t c¨¢ch d? d¨¤ng , b?ng c¨¢ch n¨¤y quy?n s? ???c c?p ho?c l?y l?i t? m?t nh¨®m , v¨¤ c¨¢c th¨¤nh vi¨ºn c?a nh¨®m ?¨® c?ng b? ?nh h??ng C¨² ph¨¢p : CREATE ROLE name C¨² ph¨¢p t??ng t? t?o role nh?ng kh?ng c¨® thu?c t¨ªnh LOGIN , Postgresql s? hi?u l¨¤ m?t nh¨®m
- 10. Role Membership (2/6) C¨² ph¨¢p c?p quy?n cho role GRANT group_role TO role1,role2¡ C¨² ph¨¢p thu h?i quy?n t? role REVOKE group_role FROM role1,role2 ...
- 11. Role Membership (3/6) Inherits rights from parnet roles ??y l¨¤ thu?c t¨ªnh cho ph¨¦p c¨¢c role thu?c m?t nh¨®m k? th?a thu?c t¨ªnh c?a nh¨®m V¨ª d? : CREATE ROLE joe LOGIN INHERIT CREATE ROLE admin NOINHERIT CREATE ROLE wheel NOINHERIT GRANT admin TO joe GRANT wheel TO admin
- 12. Role Membership (4/6) Ngay l?p t?c sau khi joe ??ng nh?p , quy?n s? ???c c?p cho joe v¨¤ th¨ºm v¨¤o ?¨® l¨¤ joe c?ng ???c c?p th¨ºm quy?n t? admin , v¨¬ joe th?a k? t? admin , Tuy nhi¨ºn , quy?n c?p cho wheel s? kh?ng c¨® hi?u l?c , th?m ch¨ª joe l¨¤ th¨¤nh vi¨ºn d¨¢n ti?p c?a wheel , v¨¬ admin c¨® thu?c t¨ªnh NOINHERIT , n¨® kh?ng cho ph¨¦p th?a k? quy?n t? wheel, sau ?¨® : SET ROLE admin L?nh n¨¤y s? c?p quy?n cho admin m¨¤ kh?ng c?p cho joe , sau ?¨® :
- 13. Role Membership (5/6) SET ROLE wheel H? th?ng s? c?p quy?n cho wheel v¨¤ kh?ng c?p quy?n cho m?t trong hai joe ho?c admin Nh?ng c?ng c¨® th? ph?c h?i b?ng c¨¢ch : SET ROLE joe SET ROLE NONE RESET ROLE SET ROLE lu?n ch?p nh?n ch?n b?t c? m?t role n¨¤o m¨¤ c? b?n v¨¤ c¨® th? ??ng nh?p
- 14. Role Membership (6/6) X¨®a Role C¨² ph¨¢p : DROP ROLE name
- 15. Presentation Template Questions & Answers ?
- 16. Presentation Template Thanks for your attention!