472,779 Members | 1,772 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Granting DML privileges on all the tables of a schema to a user

Hi,

I want to grant only the connect, select, insert, update privileges on
all the tables of a schema to a particular user/group
Initially, i had revoked all the privileges from public.

It seems that the privileges Select, Insert, Update can be given only
on a table level and not on the schema level.
I can iterate and get the script for the select privileges for all the
tables and execute it.

However, if the admin user creates the table in that schema, i will
need to grant the select, insert, update privs for newly created table
to the user again.

Is there some other way to realize that(like giving select, insert,
update privs on all the tables of that schema)

Rahul

Sep 3 '07 #1
3 4621
use trigger on create.
Sep 4 '07 #2
Ekta wrote:
use trigger on create.
There are no CREATE-triggers in DB2 (yet).

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Sep 4 '07 #3
On Sep 4, 1:43 pm, Knut Stolze <sto...@de.ibm.comwrote:
Ekta wrote:
use trigger on create.

There are no CREATE-triggers in DB2 (yet).

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Hi,

What should be done in this case(no create triggers in DB2 as yet)

Rahul

Sep 4 '07 #4

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

Similar topics

2
by: Ted | last post by:
How do I grant all privileges for a schema that has a large number of existing tables, procedures, functions, etc to a newly created role, without having to issue a grant statement for each object...
4
by: Wade Chy | last post by:
Hi All I am in a situation where I have to grant select privileges on tables owned by a different owner to a specific role. I am logged in as system/sysdba. I have created a new role...
2
by: LazyAnt | last post by:
Hello, I have DB2 v8.1 for Linux for a class environment; each user has his/her own database as dbadm and they are suppose to study queries from another database. They have the right...
7
by: datapro01 | last post by:
Hello, I am using the following: DB2 UDB V8.1.1 AIX 5L I need to know if there is a way to set up a table so that a particular group has read access to all of the rows in the table and update...
1
by: zeus | last post by:
Hi there, I am using Postgresql 7.3 and I want to grant select rights to a user on all tables in a schema, including those that may be created in the future but whose names are not yet known. I...
14
by: Bob Stearns | last post by:
I just created a new user and granted connect and select on a single view, only. When I connect to my database, the new user has at least select privileges on the whole database. What am I doing...
5
by: Rahul B | last post by:
Hi, I am having the following issues while trying to restrict the current user from creating any objects. Below is the privileges for the user and response when i try to create a table in that...
1
by: gdev | last post by:
Having some trouble getting my head around setting access to specific schemas- here's my problem: I've created a specific schema that I only want certain users to control Problem: Even...
6
by: Frank Swarbrick | last post by:
I feel like an idiot for asking this, but neither I nor my DBA can figure this out. How do you create a database object that does not implicitly allow access by any defined user? For instance,...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

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.