Stack Overflow
Stack Overflow

Questions tagged [database-permissions]

238 questions
0
votes
1 answer

On calling a stored procedure of two different schema stored procedure of secont one not getting executed

Connection connection = DriverManager.getConnection(DB_URL,userName,passWord); ArrayDescriptor des = ArrayDescriptor.createDescriptor("ARRAY_TABLE", connection); ARRAY array_to_pass = new ARRAY(des,connection,ssoIDs); …
Sathish
  • 13
  • 1
  • 4
0
votes
2 answers

Prevent a particular table being modified in SQL by a particular user

As the title says, however i have tried everything to prevent a user from modifying this table with no luck For some reason DENY do not exist in the mySQL 5.5 manual so the following doesn't work DENY ALL ON OBJECT::database.table TO user DENY ALL…
Graeme
  • 124
  • 1
  • 7
0
votes
1 answer

how to set permissions for sql database?

I'm trying to host an asp.net website using iis 5.1 on my computer using xp pro. I'm using windows authentication in iis. Folder permissions for the site are set to allow authenticated users. Impersenation has been set to true in the web.config…
see_sharp_guy
  • 239
  • 4
  • 12
0
votes
3 answers

Is Oracle DBA Privilege include "CREATE ANY TABLE" role?

I Just need to create table from a user to any user under the same DB. letz consider 3 Schemas. Schema_1,Schema_2 and Schema_3. schema 1 had DBA Privilege. Is it possible to table in SChema_2 or Schema_3 from Schema_1???? or we need to give this…
King
  • 31
  • 2
  • 2
  • 6
0
votes
8 answers

Tool for editing MySQL table permissions?

Is there a tool that makes the task of editing user privileges easier on a MySQL database? I've got nearly 100 tables to work through for 4 users, each with different per-table grants, which is getting tedious via phpMyAdmin. It'll get a lot more…
Polynomial
  • 27,674
  • 12
  • 80
  • 107
0
votes
1 answer

MySQL Permissions Over User

My friend has a VPS. He trusts me and more or less will help me do anything I want to do. I am using a number of MySQL users (less privileged) and databases. For example, I am my_user, and I created mydomain_select and mydomain_insert to isolate…
Ethan Reesor
  • 2,090
  • 1
  • 23
  • 40
-1
votes
2 answers

How to change read_only to read_write in vb.net sql database connection?

How to change read_only to read_write in vb.net SQL Server database connection? Error message: Failed to update databse because the database is read_only
Ray
  • 11
  • 1
  • 4
-1
votes
1 answer

Is it reasonable to rebuild the relationship between the relationship table and other tables?

The demand is this: a user belongs to multiple departments, and the roles in each department are different, and each role has different permissions. The general idea is You need to build another layer of relationships on the relationship table. I…
Programmer YG
  • 1
-1
votes
1 answer

How to grant the privilege of creating a session to a user or role in PostgreSQL?

I am migrating this Oracle command to PostgreSQL: GRANT CREATE SESSION TO user; Please suggest to me how I can migrate the above command.
rashmi
  • 47
  • 1
  • 3
  • 8
-1
votes
1 answer

Altering view/access permissions for a schema in DB2

I am working around a workaround to a "feature" in IBM DB2. This fancy database has a "feature" in it which if I try to use a CREATE TABLE statement and it doesn't find the schema, it will create this schema for me, even if I don't want it to. This…
theGreenCabbage
  • 5,197
  • 19
  • 79
  • 169
-1
votes
1 answer

Linked SQL table in Access 2003 (!) not updatable

I'm working in a legacy app for the moment, upgrading Access 2003 to link to SQL Server tables (2008 R2 or later). With tables linked by code, I can insert, but not update or delete. I've tried everything on the web, no dice. Details below. Being…
Ed The Dev Prog
  • 21
  • 4
-1
votes
1 answer

Permission setting on DNN SQL Server database

I ran into problems when trying to upgrade to DNN7.1.1 yesterday. Started messing with permissions on the ISS (and file system) and now I can´t log in to DNN. There is database contact. A DNN module outside login-area works perfectly, loads and save…
Asle G
  • 568
  • 7
  • 27
-2
votes
1 answer

"PL/SQL: Statement ignored" error in Java

When I call a PL/SQL of particular schema in Java file it is getting executed and retrieves the result. But when I call another PLSQL in the same Java file of different schema it shows an error saying: Message: `ORA-06550: line 1, column 7:…
Sathish
  • 13
  • 1
  • 4
1 2 3
…
15
16