473,715 Members | 2,142 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PostgreSQL Roles, Groups and Policies.

11 New Member
-In PostgreSQL, what is the difference between a Role and a Group, exactly? How do they relate to one another, and which one(s) can be asigned to another?

-Can Policies be assigned to one or more aggregating entities in PostgreSQL, or are they just left on their own? If not, what can a Policy be assigned to?
Sep 14 '21 #1
0 3980

Sign in to post your reply or Sign up for a free account.

Similar topics

125
14781
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from software giant such as Microsoft SQL Server, Oracle, and Sybase? Is PostgreSQL reliable enough to be used for high-end commercial application? Thanks
1
367
by: Varun | last post by:
In my application i have users who can belong to different groups and can have different roles. Groups can be administrators,schedulors,Recordkeepers etc., Roles recordkeepingfullaccess,recordkeepingreadonlyaccess etc., how can i authenticate the user and once he/she logins in one system if someone else tries to login from some other system wiht his user login and pwd he should get a message that he u have already logged in the machine...
2
1770
by: Roderick A. Anderson | last post by:
While playing at a new/different configuration in my brand spanking new Pg 7.4 instance :-) I noticed in the documentation that GROUPs are not in the SQL Standard. So I go a looking and notice that Oracle does have ROLEs and that they are quite different in how they are used. Looking at the TODO list I see there is an entry about adding some GROUPy stuff so ROLEs can be implemented. How close will ROLEs be with these (object ownership)...
4
2275
by: Marty Underwood | last post by:
Okay the subject line explains a scenario I just had to tackle but I am looking for a better way. The current way: 1) Use forms authentication. 2) Query Active Directory and bind to a user object if no exception create custom authentication ticket. 3) But I also needed Role based security within the app. So I used SQL server 2k DTS package to get the members of the AD group and then created a
20
6627
by: Keith G. Murphy | last post by:
I'm trying to get a feel for what most people are doing or consider best practice. Given a mod_perl application talking to a PostgreSQL database on the same host, where different users are logging onto the web server using LDAP for authentication, do most people 1) have the web server connecting to the database using its own user account (possibly through ident), and controlling access to different database entities strictly through...
6
1483
by: Chris | last post by:
I'm looking to protect some pages using the Membership provider (ADS) built into .NET 2.0. In order to protect these pages, whose details are stored inside a SQL Server table with columns id,name,url,parentid etc. I need to link them into some roles, or groups. So only certain groups from our Active Directory can access certain pages. The problem I'm facing is that ASP.NET 2.0 seems to restrict you to using its Role provider model only....
2
1082
by: Francis Reed | last post by:
Hi I haven a question concerning roles and membership in asp.net 2.0. I work for an online university, and we would like to implement role based security for our portal. Currently our university has 11 courses, which fall in 5 semesters, and each course is then subdivived into approx 5 or more groups, and in each group we have teachers, students, teacherAssistants. A quick calculation can approximate that we have to create about 825...
9
4276
by: Mike Hofer | last post by:
BACKGROUND: We've designed a Website for a client that will be deployed across multiple physical locations. The site will be hosted from a corporate NOC, and administered by the IT group there. The site's end-users tend to fill each others' roles on a pretty frequent basis. Their permissions in the system have to be extremely flexible. We initially wanted to use role-based security, defining concrete roles, but when we realized how these...
1
1050
by: Goofy | last post by:
Hi, I am working in an organisation developing an asp.net application. The application and general use of .NET may well expand to other applications, so I need to start thinking about the arcitechture changes that will be needed to support restriction of visibility of resources or permissions to perform an action. Management of Groups etc, administration of users in groups. The obvious one which springs to mind is the use of Groups...
1
5600
by: Andy | last post by:
Hi, I currently have my application setup and built using Windows Authentication (WindowsPrincipal). For security checks, I simply do an IsInRole call on the Principal. The role permissions are hard- coded, something like this: private static string allowedReadRoles = new string { "Sales", "Ordering" };
0
8817
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8715
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9093
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6641
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5964
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4472
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4734
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3171
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2532
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.