473,405 Members | 2,185 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

users rights per table

I have to implement a structure of rights.
I'm intrested if postgresql can restrict these operations(insert,
update, select, delete) for a specified postgresql user.
If this is possible, please tell me were could I find some
documentation about this subject.

Thank you.

Nov 23 '05 #1
4 1281
> I have to implement a structure of rights.
I'm intrested if postgresql can restrict these operations(insert,
update, select, delete) for a specified postgresql user.
If this is possible, please tell me were could I find some
documentation about this subject.


Can we assume that you have not yet read the section on 'GRANT'
in the online documentation on the postgreSQL website?
--
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #2
> I have to implement a structure of rights.
I'm intrested if postgresql can restrict these operations(insert,
update, select, delete) for a specified postgresql user.
If this is possible, please tell me were could I find some
documentation about this subject.


Can we assume that you have not yet read the section on 'GRANT'
in the online documentation on the postgreSQL website?
--
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #3
victor wrote:
I have to implement a structure of rights.
I'm intrested if postgresql can restrict these
operations(insert, update, select, delete) for a specified postgresql
user.
If this is possible, please tell me were could I find some
documentation about this subject.


Read the reference page of GRANT.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #4
victor wrote:
I have to implement a structure of rights.
I'm intrested if postgresql can restrict these
operations(insert, update, select, delete) for a specified postgresql
user.
If this is possible, please tell me were could I find some
documentation about this subject.


Read the reference page of GRANT.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: K Finegan | last post by:
I have an archival process on a large database that runs once a month. At the beginning of the process the triggers and indexes on the tables whose data is moved are dropped, the data is moved and...
5
by: Ross Presser | last post by:
As our customers demand that we tighten our IT security in the company, I've been asked to prepare a report quarterly showing, for each user in Active directory, what his effective permissions are...
5
by: JM | last post by:
I need to take all the user/groups and permissions and migrate them to SQL Server, how can this be done easily?
4
by: Kristof Despiere | last post by:
Suppose you have one domain, filled with a couple of users. What needs to be done now is I need to start a windows application from a webform by pressing a button on the webform (for example). ...
2
by: A.M | last post by:
Hi, I am using WebForms authentication. What would be the best way to prevent two person login with same userID at the same time? Thanks, Alan
4
by: Kittikun | last post by:
I am currently using the BACKUP DATABASE method to backup my database. Everything works fine, except for users. I created various users with sp_addlogin to access this database and they are located...
1
by: javasapphire | last post by:
hi , I have a simple application where there are seven groups which four users can access .Now an user can have access to one or more groups ..say user1 has access to group 1 and group 3.Also...
6
by: Matt Adamson | last post by:
Guys, I'm unsure how to use windows authentication in an intranet application. I'd like to user existing windows account to identify users however the issue I have is how to then add settings to...
3
by: evenlater | last post by:
I have an Access application on a terminal server. Sometimes my users need to export reports to pdf, rtf or xls files and save them to their own client device hard drives. They can do that right...
7
by: sweetfalguni | last post by:
hello, I want to create 2or 3 users in Msaccess 2007 inwhich first user say namely 'Administrator' has rights to access or edit or delete or modify table,forms,reports. Second user say namely'...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.