You could, of course, leverage dynamic SQL, i.e.
FOR x IN (SELECT * FROM user_tables)
LOOP
EXECUTE IMMEDIATE 'GRANT SELECT ON ' || x.table_name || ' TO <<someone>>';
END LOOP;
Of course, if you’re doing this sort of thing, you’d normally grant the privileges to a role and grant that role to one or more users.
Login as your user name and then run the following
declare
cursor c1 is select table_name from user_tables;
cmd varchar2(200);
begin
for c in c1 loop
cmd := ‘GRANT SELECT ON ‘||c.table_name||’ TO YOURUSERNAME’;
execute immediate cmd;
end loop;
end;
Komentarze są wyłączone
sudo apt-get remove gnome-screensaver
sudo apt-get install gnome-core
-- skype instalka ---
sudo apt-file search libQtWebKit.so.4
libqtwebkit4: /usr/lib/x86_64-linux-gnu/libQtWebKit.so.4
libqtwebkit4: /usr/lib/x86_64-linux-gnu/libQtWebKit.so.4.10
libqtwebkit4: /usr/lib/x86_64-linux-gnu/libQtWebKit.so.4.10.2
sudo apt-get install libqtwebkit4:i386
Komentarze są wyłączone
LoadModule php4_module /usr/lib/apache/1.3/libphp4.so
Addmodule mod_php4.c
Komentarze są wyłączone
# /etc/nsswitch.conf
#
# Example configuration of GNU Name Service Switch functionality.
# If you have the `glibc-doc-reference’ and `info’ packages installed, try:
# `info libc “Name Service Switch”‘ for information about this file.
passwd: compat
group: compat
shadow: compat
hosts: files dns [NOTFOUND=return] mdns4_minimal mdns4
networks: files
protocols: db files
services: db files
ethers: db files
rpc: db files
netgroup: nis
cat /etc/resolvconf/resolv.conf.d/head
# Dynamic resolv.conf(5) file for glibc resolver(3) generated by resolvconf(8)
# DO NOT EDIT THIS FILE BY HAND — YOUR CHANGES WILL BE OVERWRITTEN
nameserver 192.168.0.150
nameserver 192.168.0.151
Komentarze są wyłączone
