Monday, April 29, 2013

[SVN] - Add SVN user

Tested on Centos

Add new user account (for first time)
htpasswd -cm /etc/.svn-auth-file <username>
* It will ask for password. Provide the password and confirm again.

Add another user in the same svn-auth-file
htpasswd -m /etc/svn-auth-users <username>
or
htpasswd -m /etc/svn-auth-users <username> <password>

[Linux] - How to list linux file/folder permission on numerical value

Tested on Centos and Ubuntu.

stat -c "%a %n" *

Sample output:

777 aircrack-ng-1.1
755 abc.txt
644 root.conf



[Oracle] - Select table contains column name

Tested on Oracle11g

Return all the tables in my schema which have the column name "INST_CODE".

SELECT
table_name FROM user_tab_cols WHERE column_name = 'INST_CODE' ORDER BY table_name ASC;