오라클XE 사용자 추가 및 삭제

오라클에서 사용자 추가 / 삭제를 많이 하려다 보니 귀찮아서 cx_Oracle을 깔고 파이썬 스크립트를 만들었다.

[cc lang="python" lines="40"]
#coding: utf-8

import cx_Oracle

users = [학번1, 학번2]
def ora_useradd(username):
print “add user : %s” %username
query = ‘CREATE USER “%s” IDENTIFIED BY “%s” DEFAULT TABLESPACE users TEMPORARY TABLESPACEtemp ACCOUNT unlock’ %(username, username)
print query
conn = cx_Oracle.connect(”system”, “aksekfls”, “XE”)
cursor = conn.cursor()
cursor.execute(query)

grant_query = “GRANT connect, resource TO %s” %username
cursor.execute(grant_query)
cursor.close()

def ora_userdel(username):
print “del user : %s” %username
query = ‘DROP USER %s CASCADE’ %username
print query
conn = cx_Oracle.connect(”system”, “aksekfls”, “XE”)
cursor = conn.cursor()
cursor.execute(query)
cursor.close()

if __name__ == “__main__“:
for username in users:
try:
ora_useradd(str(username))
except:
continue
[/cc]