Month: June 2009
DROP all tables, views, stored procedures, & Sequences from Schema
Below script will help to delete all tables, constrains from user Begin for c in (select table_name from user_tables) loop execute immediate (‘drop table ‘||c.table_name||’ cascade constraints’); end loop; for c in (select view_name from user_views) loop execute immediate (‘drop view ‘||c.view_name); end loop; for c in (select sequence_name from user_sequences) loop execute immediate (‘drop…
Read MoreAuthentication vs. Authorization
It is easy to confuse the mechanism of authentication with that of authorization. In many host-based systems (and even some client/server systems), the two mechanisms are performed by the same physical hardware and, in some cases, the same software. It is important to draw the distinction between these two mechanisms, however, since they can be…
Read MoreConfigure CAS with LDAP
Here are the few steps to configure LDAP with CAS server Download CAS Server 3.3.2 from the JaSig Unzip the file in C drive. Assume C:/cas-server-3.3.2 Create new Java file (AuthenticatedLdapContextSource.java). I recommend, copy & paste the below code. package com.localentity.cas.adaptors.ldap.util; import java.util.Hashtable; import javax.naming.Context; import javax.naming.directory.DirContext; import javax.naming.directory.InitialDirContext; import org.springframework.ldap.core.support.LdapContextSource; /** * @author Krishna…
Read MoreRetrive user info from LDAP
Below code will connect the LDAP server and retrives the user information import java.util.Hashtable; import javax.naming.AuthenticationException; import javax.naming.Context; import javax.naming.NamingEnumeration; import javax.naming.NamingException; import javax.naming.directory.Attribute; import javax.naming.directory.Attributes; import javax.naming.directory.DirContext; import javax.naming.directory.InitialDirContext; import javax.naming.ldap.InitialLdapContext; import javax.naming.ldap.LdapContext; public class SimpleLDAPImpl { String userName = “YourUserId“; String passWord = “Password“; String base = “ou=People,dc=localentity,dc=com“; private Hashtable<String, String> getEnvInfo() {…
Read MoreLDAP authentication in JAVA
This is a simple example through which will connect to the LDAP Server and authenticate user. import java.util.*; import javax.naming.*; import javax.naming.directory.*; public class SimpleLDAPImpl { public static void main(String[] args) { String userName = “YourUserId“; String passWord = “Password“; String base = “ou=People,dc=companyDomain,dc=com“; // “ou=People,dc=localentity,dc=com”; String dn = “uid=” + userName + “,” +…
Read More