KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365537500' post='1303572856'] toad open cheyyagane login screen lo untayi antava avanni? yeah first nuv login aye appudu untai Developer aithe enti mama? Dev lo naaku anni access lu atleast basic vi kuda ivvakunda ivvarantava? [/quote] nenu ninnu adgutuna developer vi a ani?depends bhayya me daggara users ki ela estaru mari
KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [color=#00008B][background=transparent]SELECT[/background][/color][background=transparent] [/background][background=transparent]*[/background][background=transparent] [/background][color=#00008B][background=transparent]FROM[/background][/color][background=transparent] USER_SYS_PRIVS[/background][background=transparent];[/background][background=transparent] [/background][color=#00008B][background=transparent]SELECT[/background][/color][background=transparent] [/background][background=transparent]*[/background][background=transparent] [/background][color=#00008B][background=transparent]FROM[/background][/color][background=transparent] USER_TAB_PRIVS[/background][background=transparent];[/background][background=transparent] [/background][color=#00008B][background=transparent]SELECT[/background][/color][background=transparent] [/background][background=transparent]*[/background][background=transparent] [/background][color=#00008B][background=transparent]FROM[/background][/color][background=transparent] USER_ROLE_PRIVS[/background][background=transparent];[/background]
deals2buy Posted April 9, 2013 Report Posted April 9, 2013 [quote name='STFU' timestamp='1365537555' post='1303572859'] bhayya nuv em permissions antunav?? [/quote] two types of permissions bhayya 1) paina cheppinavi 2) against what databases or schemas I have permisions to atleast read the data? [quote name='STFU' timestamp='1365537669' post='1303572869'] nenu ninnu adgutuna developer vi a ani?depends bhayya me daggara users ki ela estaru mari [/quote] oh sry....ya developer ni nenu... nuvvu cheppinattu toad login lo anni unnayi LDAP editor ante for what?
deals2buy Posted April 9, 2013 Report Posted April 9, 2013 [quote name='STFU' timestamp='1365537940' post='1303572897'] [color=#00008B][background=transparent]SELECT[/background][/color][background=transparent] [/background][background=transparent]*[/background][background=transparent] [/background][color=#00008B][background=transparent]FROM[/background][/color][background=transparent] USER_SYS_PRIVS[/background][background=transparent];[/background][background=transparent] [/background] [color=#00008B][background=transparent]SELECT[/background][/color][background=transparent] [/background][background=transparent]*[/background][background=transparent] [/background][color=#00008B][background=transparent]FROM[/background][/color][background=transparent] USER_TAB_PRIVS[/background][background=transparent];[/background] [color=#00008B][background=transparent]SELECT[/background][/color][background=transparent] [/background][background=transparent]*[/background][background=transparent] [/background][color=#00008B][background=transparent]FROM[/background][/color][background=transparent] USER_ROLE_PRIVS[/background][background=transparent];[/background] [/quote] first 2 queries ki em raale...blank last query ki GRANTEd_ROLE deniki? ADMIN_OPTION - NO DEFAULT_ROLE - YES OS_GRANTED - NO
KOTC Posted April 9, 2013 Author Report Posted April 9, 2013 [quote name='Kaarthikeya' timestamp='1365538174' post='1303572913'] first 2 queries ki em raale...blank last query ki GRANTEd_ROLE deniki? ADMIN_OPTION - NO DEFAULT_ROLE - YES OS_GRANTED - NO [/quote] paina chepinavi ante ?? login lo ani unai ante chudu okasari database names.inka permissions ante depends bhayya requirement bhatti permissions estaru users ki.me daggara ela estaru. select name from v$database; idi chudu nenu chepinatu neku ani views ki permission ivaru try aithe cheyi LDAP idea ledhu vayya
deals2buy Posted April 10, 2013 Report Posted April 10, 2013 [quote name='STFU' timestamp='1365540943' post='1303573228'] paina chepinavi ante ?? [/quote][img]http://www.manadb.com/Smileys/default/click.gif[/img] [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] [quote name='STFU' timestamp='1365540943' post='1303573228'] login lo ani unai ante chudu okasari database names.inka permissions ante depends bhayya requirement bhatti permissions estaru users ki.me daggara ela estaru. select name from v$database; idi chudu nenu chepinatu neku ani views ki permission ivaru try aithe cheyi LDAP idea ledhu vayya [/quote]ya login appudu databases anni chupistunnayi bhayya....andulo naaku only Dev ki ichaaru [CODE] select name from v$database; [/CODE] ee query run cheste naa database name vachindi... naako doubt...idi database aithe lopala undevi tables and schemas aa? if so, Dev mothaniki okate database untunda?
deals2buy Posted April 10, 2013 Report Posted April 10, 2013 Oracle vaallu evaru lera? nenu naa userid schema lo oka table create chesanu... aa create chesina tables lo values insert cheddam ani chustunte [font=courier new,courier,monospace]ORA-01950: no privileges on tablespace[/font] antondi ante naaku ippudu only DDL commands ki matrame permissions ichinatta?
CheGuevara Posted April 10, 2013 Report Posted April 10, 2013 [quote name='Kaarthikeya' timestamp='1365603923' post='1303576558'] Oracle vaallu evaru lera? nenu naa userid schema lo oka table create chesanu... aa create chesina tables lo values insert cheddam ani chustunte [font=courier new,courier,monospace]ORA-01950: no privileges on tablespace[/font] antondi ante naaku ippudu only DDL commands ki matrame permissions ichinatta? [/quote] ask them to give privileges on tablespace grant unlimited tablespace to <username>:
KOTC Posted April 10, 2013 Author Report Posted April 10, 2013 [quote name='Kaarthikeya' timestamp='1365601674' post='1303576371'] [img]http://www.manadb.com/Smileys/default/click.gif[/img] ya login appudu databases anni chupistunnayi bhayya....andulo naaku only Dev ki ichaaru [CODE] select name from v$database; [/CODE] ee query run cheste naa database name vachindi... naako doubt...idi database aithe lopala undevi tables and schemas aa? if so, Dev mothaniki okate database untunda? [/quote] kadhu vayya neku e database tho pani undi?deni meda work cheyamanaru?deniki user login echaru? a details neku telusu unte ne doubts ani clear avuthai like database name permission enti ani. schemas ante users. e link chudu http://www.rastertek.com/oratut04.html naako doubt...idi database aithe lopala undevi tables and schemas aa? database lopala chala untai vayya koncham complicated.
Bondu_Babu Posted April 10, 2013 Report Posted April 10, 2013 [quote name='CheGuevara' timestamp='1365605362' post='1303576750'] ask them to give privileges on tablespace grant unlimited tablespace to <username>: [/quote] Agreed quota unlimited change chesadu don't worry Dba ni aadugu
deals2buy Posted April 10, 2013 Report Posted April 10, 2013 [quote name='CheGuevara' timestamp='1365605362' post='1303576750'] ask them to give privileges on tablespace grant unlimited tablespace to <username>: [/quote] unlimited space ante isthara? asalu naaku min space anna istharo ledo ani doubt ga undi [quote name='STFU' timestamp='1365610789' post='1303577524'] kadhu vayya neku e database tho pani undi?deni meda work cheyamanaru?deniki user login echaru? a details neku telusu unte ne doubts ani clear avuthai like database name permission enti ani. schemas ante users. e link chudu [url="http://www.rastertek.com/oratut04.html"]http://www.rastertek.com/oratut04.html[/url] naako doubt...idi database aithe lopala undevi tables and schemas aa? database lopala chala untai vayya koncham complicated. [/quote] basically naadi Oracle kaadu bhayya..but some how I asked for access to Oracle and they gave me some database in Dev. So, nenu toad lo login ayyaka I'm exploring everthing since, its my first time using oracle. oka table create chesanu naaku vachina sql tho..then table lo values insert cheddam ani chustunte no tablespace ani aa paina cheppina error vastondi [quote name='Bondu_Babu' timestamp='1365611844' post='1303577618'] Agreed quota unlimited change chesadu don't worry Dba ni aadugu [/quote] emani adagaalo exact ga cheppu bhayya...asalu nenu deeni meeda pani cheyyanu..but appudeppudo adigithe naku oracle ki access ichaaru...nenu nerchukodaaniki or practice cheyyadaniki dev vaadukuntunna
CheGuevara Posted April 10, 2013 Report Posted April 10, 2013 [quote name='Kaarthikeya' timestamp='1365612481' post='1303577693'] unlimited space ante isthara? asalu naaku min space anna istharo ledo ani doubt ga undi basically naadi Oracle kaadu bhayya..but some how I asked for access to Oracle and they gave me some database in Dev. So, nenu toad lo login ayyaka I'm exploring everthing since, its my first time using oracle. oka table create chesanu naaku vachina sql tho..then table lo values insert cheddam ani chustunte no tablespace ani aa paina cheppina error vastondi emani adagaalo exact ga cheppu bhayya...asalu nenu deeni meeda pani cheyyanu..but appudeppudo adigithe naku oracle ki access ichaaru...nenu nerchukodaaniki or practice cheyyadaniki dev vaadukuntunna [/quote] dev environment e kada mama.....access ichi tablespace meeda privilege lekunte enduku aa bokkalo access....... ela adugu vallani...naaku access icharu but naaku default tablespace meeda pribileges levu and i cannot create a single table ani.....so either aa tablespace meeda privilege evvandi lekunte naaku antu oka 5GB tablespace create chesi and mek that as my default tablespace ani adugu................. bongulo dev e kada istaru
deals2buy Posted April 10, 2013 Report Posted April 10, 2013 [quote name='CheGuevara' timestamp='1365612706' post='1303577713'] dev environment e kada mama.....access ichi tablespace meeda privilege lekunte enduku aa bokkalo access....... ela adugu vallani...naaku access icharu but naaku default tablespace meeda pribileges levu and i cannot create a single table ani.....so either aa tablespace meeda privilege evvandi lekunte naaku antu oka 5GB tablespace create chesi and mek that as my default tablespace ani adugu................. bongulo dev e kada istaru [/quote] deve ey anuko...but naadi asalu Oracle team ey kaadu...even vaalla work kuda em naaku teleedu...but appudeppudo adaggane access icharu server ki...maree 5GB antha naakenduku le... ivaala process endo kanukkoni adugutha tablespace ivvamani...thanks mama
nexus Posted April 10, 2013 Report Posted April 10, 2013 Session level lo system statistics ni ignore cheyataniki adhedho oka unsupported hidden parameter undhi. Monnepudu chusa ekado, gurthu ravatle...evari kaina idea undhaa??
KOTC Posted April 11, 2013 Author Report Posted April 11, 2013 [quote name='nexus' timestamp='1365637195' post='1303580696'] Session level lo [b]system statistics ni ignore cheyataniki adhedho oka unsupported hidden parameter[/b] undhi. Monnepudu chusa ekado, gurthu ravatle...evari kaina idea undhaa?? [/quote] ????
Recommended Posts