KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365535810' post='1303572679'] Anyone around? [/quote] what's up yo!!
deals2buy Posted April 9, 2013 Report Posted April 9, 2013 [quote name='STFU' timestamp='1365535856' post='1303572690'] what's up yo!! [/quote] whatsup bhayya? ivaala first time Oracle Toad using...naaku Oracle bhi em raadu and i am developer....so naaku asalu em databases ki or em schemas ki access icharo ela telusukovali TOAD use chesi? or else daaniki edaina query unte adanna cheppu
Gachibowli_Diwakar Posted April 9, 2013 Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365535970' post='1303572705'] whatsup bhayya? ivaala first time Oracle Toad using...naaku Oracle bhi em raadu and i am developer....so naaku asalu em databases ki or em schemas ki access icharo ela telusukovali TOAD use chesi? or else daaniki edaina query unte adanna cheppu [/quote] niku database name .. aah database lo unde schema name and password istharu .. that way around u can co-relate
deals2buy Posted April 9, 2013 Report Posted April 9, 2013 [quote name='Silence..Please' timestamp='1365536201' post='1303572726'] niku database name .. aah database lo unde schema name and password istharu .. that way around u can co-relate [/quote]schema name ichaaru....but database name em ivvale naaku ichina password tho login ayyanu..but ekkada em nokkalo ardhamaitaledu
KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365535970' post='1303572705'] whatsup bhayya? ivaala first time Oracle Toad using...naaku Oracle bhi em raadu and i am developer....so naaku asalu em databases ki or em schemas ki access icharo ela telusukovali TOAD use chesi? or else daaniki edaina query unte adanna cheppu [/quote] bhayya chepinatu db name estaru more over tnsnames kuda estaru.so a tnsnames lo service name ani untndi adi database name.inka ne user details estaru ga database ki. sample tnsnames.ora file ila ne undali ani em ledhu different ga kuda untndi DBNAME= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =hostname)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DBNAME) ) ) service name dbname undali ani emledhu malli
deals2buy Posted April 9, 2013 Report Posted April 9, 2013 [quote name='STFU' timestamp='1365536593' post='1303572770'] bhayya chepinatu db name estaru more over tnsnames kuda estaru.so a tnsnames lo service name ani untndi adi database name.inka ne user details estaru ga database ki. sample tnsnames.ora file ila ne undali ani em ledhu different ga kuda untndi DBNAME= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =hostname)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DBNAME) ) ) [/quote] tnsnames and database names em ivvaledu bhayya just schema and login details icharu anthe can't we determine using a query or toad of what permissions do we have?
KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [img]http://www.toadworld.com/Portals/0/blogimages/Bert%20Scalzo/BertBlog101409-1.gif[/img]
deals2buy Posted April 9, 2013 Report Posted April 9, 2013 naa toad endo variety ga undi mama..ila ledu version 10.5.1.3 ani undi...tool llo ekkada ivi kanipinchatle
KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365536707' post='1303572784'] tnsnames and database names em ivvaledu bhayya just schema and login details icharu anthe can't we determine using a query or toad of what permissions do we have? [/quote] neku permssion unadavu anukunta okasari [font=arial,helvetica,sans-serif][size=4][color=#000000]select * from session_privs; [/color][/size][/font] [font=arial,helvetica,sans-serif][size=4].[color=#000000]lekapothe [/color][/size][/font] [font=arial,helvetica,sans-serif][size=4][color=#000000]select * from username.session_privs;[/color][/size][/font] [font=arial,helvetica,sans-serif][size=4][color=#000000]idi try cheyi [/color][/size][/font]
KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365537102' post='1303572819'] naa toad endo variety ga undi mama..ila ledu version 10.5.1.3 ani undi...tool llo ekkada ivi kanipinchatle [/quote] nuv ekkada entry chesav mari username password lu akkade untdi database name inka details as it is ga image lo. version change aithe koncahm diff kani alane details adgutundi mari
KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365536707' post='1303572784'] tnsnames and database names em ivvaledu bhayya just schema and login details icharu anthe can't we determine using a query or toad of what permissions do we have? [/quote] em permission estaru anukunav neku developer kadha?
deals2buy Posted April 9, 2013 Report Posted April 9, 2013 [quote name='STFU' timestamp='1365537129' post='1303572822'] neku permssion unadavu anukunta okasari [font=arial,helvetica,sans-serif][size=4][color=#000000]select * from session_privs; [/color][/size][/font] [font=arial,helvetica,sans-serif][size=4].[color=#000000]lekapothe [/color][/size][/font] [font=arial,helvetica,sans-serif][size=4][color=#000000]select * from username.session_privs;[/color][/size][/font] [font=arial,helvetica,sans-serif][size=4][color=#000000]idi try cheyi [/color][/size][/font] [/quote] ee query run cheste [CODE]select * from session_privs;[/CODE] ivi vachayi mama CREATE SESSION ALTER SESSION CREATE TABLE CREATE SYNONYM CREATE VIEW CREATE SEQUENCE CREATE DATABASE LINK CREATE PROCEDURE CREATE TRIGGER CREATE MATERIALIZED VIEW CREATE ANY DIRECTORY CREATE TYPE CREATE INDEXTYPE CREATE DIMENSION CREATE ANY CONTEXT DROP ANY CONTEXT DEBUG CONNECT SESSION DEBUG ANY PROCEDURE EXPORT FULL DATABASE IMPORT FULL DATABASE CREATE JOB
deals2buy Posted April 9, 2013 Report Posted April 9, 2013 [quote name='STFU' timestamp='1365537232' post='1303572831'] nuv ekkada entry chesav mari username password lu akkade untdi database name inka details as it is ga image lo. version change aithe koncahm diff kani alane details adgutundi mari [/quote] toad open cheyyagane login screen lo untayi antava avanni? [quote name='STFU' timestamp='1365537347' post='1303572843'] em permission estaru anukunav neku developer kadha? [/quote] Developer aithe enti mama? Dev lo naaku anni access lu atleast basic vi kuda ivvakunda ivvarantava?
KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365537425' post='1303572849'] ee query run cheste [CODE]select * from session_privs;[/CODE] ivi vachayi mama CREATE SESSION ALTER SESSION CREATE TABLE CREATE SYNONYM CREATE VIEW CREATE SEQUENCE CREATE DATABASE LINK CREATE PROCEDURE CREATE TRIGGER CREATE MATERIALIZED VIEW CREATE ANY DIRECTORY CREATE TYPE CREATE INDEXTYPE CREATE DIMENSION CREATE ANY CONTEXT DROP ANY CONTEXT DEBUG CONNECT SESSION DEBUG ANY PROCEDURE EXPORT FULL DATABASE IMPORT FULL DATABASE CREATE JOB [/quote] bhayya nuv em permissions antunav??
Recommended Posts