FAQ Database Discussion Community


PostgreSQL Prevent updating columns EVERYONE

postgresql,privileges
I want to prevent users (everyone) updating a particular column of a topic to prevent circular dependencies. CREATE TABLE Topic( id serial NOT NULL PRIMARY KEY, contenxt text DEFAULT NULL, -- can be freely updated Dependency1 serial REFERENCES Topic(id) ON DELETE RESTRICT, -- CAN'T be updated Dependency2 serial REFERENCES Topic(id)...

Handling users of phpMyAdmin

mysql,security,phpmyadmin,user,privileges
Hi stackoverflow community, I have some doubts in how to manage the users in phpMyAdmin, I am starting a project but I see multiple users with ALL PRIVILEGES. I should choose one user, set my password, and then delete the other ones? Having multiple users with ALL PRIVILEGES and without...

HTML transient modal window

javascript,firefox,modal-dialog,firefox-addon,privileges
We have a legacy web application. At various places it opens a window with the help of Privilege Manager on Firefox to get the needed result. Some of these windows open a Java applet or a PDF document. The client machines are updating Firefox and Privilege Manager is gone. What...

MySql can not grant privileges to root

mysql,root,privileges,grant
I ran command grant all privileges on *.* to 'root'@'%' identified by 'root'; And it keep showing following error 11:43:51 grant all privileges on . to 'root'@'%' identified by 'root' Error Code: 1045. Access denied for user 'root'@'%' (using password: YES) 0.00045 sec I also checked User table on Mysql...

Setting permissions to broadcast messages across multiple desktops

c++,winapi,privileges,messages
Hi, I'm trying to send messages between applications that are located on different desktops. In order to accomplish this, I'm using BroadCastSystemMessage using BSM_ALLDESKTOPS set for LPDWORD lpdwRecipients parameter. As the MSDN documentation says, BSM_ALLDESKTOPS - Broadcast to all desktops. Requires the SE_TCB_NAME privilege. In order to meet this...

Change network settings in Linux without root privilege

c,linux,network-programming,root,privileges
The settings I'm talking about are IP, subnet mask and default gateway (set and get). For setting all of these I use the ioctl function along with options like SIOCSIFADDR and SIOCSIFNETMASK. For getting the IP and mask I use the same approach but with options like SIOCGIFADDR. For getting...

C# WinForm application - How to save connection string (SQLite)

c#,winforms,connection-string,privileges
I have a winform app in .NET 4.0 with database (SQLite). I need to add an option for user to be able to change the path to the file containing the database - in short, to change the connection string. I used app.config to save connection string like this: <connectionStrings>...

_winreg.SaveKey Error - A required privilege is not held by the client

python,registry,privileges,winreg
I want to save the registry key "Run" using _winreg in Python. This is my code: import _winreg key = _winreg.OpenKey(_winreg.HKEY_LOCAL_MACHINE, r'Software\Microsoft\Windows\CurrentVersion\Run') _winreg.SaveKey(key, "C:\key.reg") When executing, I get a Windows error message: "A required privilege is not held by the client" Can anyone see what is wrong?...

Oracle Indexes EXECUTE object privilege

database,oracle,indexing,privileges,oracle12c
Update: I asked that since if we run this statement: select * from v$object_privilege where object_type_name = 'INDEX'; and we obtain this: . So i assume that certain users may / may not be able to execute these indexes, as a form of security. Or am i wrong and none...

Connect to sqlplus with another linux user than oracle

linux,oracle,database-connection,sqlplus,privileges
I installed Oracle with sqlplus with user oracle (linux - CentOS). If I try to connect to database being oracle everything goes as expected (sqlplus / as sysdba for example), but I need to do the same thing (maybe not as sysdba, but as a user from database) being another...

Macports' dropping of privileges causing Xcode licence problems

xcode,licensing,sudo,macports,privileges
I am trying to install some ports using Macports on OS X but as soon as the installation tries to invoke the C compiler I get: Agreeing to the Xcode/iOS license requires admin privileges, please re-run as root via sudo. Context: I have run sudo xcodebuild -license and successfully agreed...

PLS-00201 identifier must be declared referencing user defined type as SYS

oracle,plsql,privileges,user-defined-types
I am having a problem with certain defined TYPEs in my package create scripts - I receive the following for certain TYPEs PLS-00201 identifier must be declared For instance; Error(7,23): PLS-00201: identifier 'another_schema.some_table_type' must be declared Error(8,23): PLS-00201: identifier 'another_schema.some_object_type' must be declared I should note that I am changing...