Grudzień « 2014 « Różności …

Różności …

11 grudnia 2014

grant select on all tables

Zaszufladkowany do: Bazy danych,Oracle — Tagi: — Jacek @ 16:58

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;

ubuntu pakiety

Zaszufladkowany do: Linux — Tagi: — Jacek @ 14:02
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

3 grudnia 2014

create self signed certificate

Zaszufladkowany do: Linux — Jacek @ 19:04

http://www.akadia.com/services/ssh_test_certificate.html

php4 mod_php4.c

Zaszufladkowany do: Linux — Tagi: — Jacek @ 18:33

LoadModule php4_module /usr/lib/apache/1.3/libphp4.so
Addmodule mod_php4.c

2 grudnia 2014

Ubuntu – DNS

Zaszufladkowany do: Linux — Tagi: — Jacek @ 12:09

# /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

Strona startowa: www.jaceksen.pl