472,371 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,371 software developers and data experts.

how to grant sysdba privileges to user

ramanan ram
i am using toad11.5 version ,here a schema name is(ex:sa) database name(ex:wttest).i need full backup of wttest DB.
now i am trying to get through rman(recovery manager) script in databse browser.here, its showing one message 'you must have the sysdba privilege to use RMAN'

how can i give the sysdba privilege grant to the user .
but i tried,while i am open the user in tns,mode set as sysdba .but its showing insuffient privileges..

plz help..
Jun 16 '12 #1

✓ answered by bharthi

Hi Ramanan sir ,
Try this one,

grant connect ,resource,DBA to USER

3 60499
rski
700 Expert 512MB
Expand|Select|Wrap|Line Numbers
  1. GRANT SYSDBA TO <USERNAME>
  2.  
But only user with SYSDBA privilege can do that.
Jun 16 '12 #2
rski i tried this query but insufficient privileges error display ..
thanks in advance..
Jun 20 '12 #3
bharthi
20
Hi Ramanan sir ,
Try this one,

grant connect ,resource,DBA to USER
Jul 2 '12 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: DC_DBA | last post by:
I want to 'grant sysdba to a user' for an application. (At least that is what I believe so far after having had this problem dumped on me 2 days ago.) The support we get from the application vendor...
4
by: Amardeep Verma | last post by:
Hi, I have a quick question. Which role/privileges are required before a user can give the statement "GRANT ALL PRIVILEGES"? Thanking you in Advance Have a nice day
4
by: Wade Chy | last post by:
Hi All I am in a situation where I have to grant select privileges on tables owned by a different owner to a specific role. I am logged in as system/sysdba. I have created a new role...
0
by: Charles Cantrell | last post by:
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of Mandrake, I believe), using the binary 4.0.13 standard release. The set up and start up all were normal, as far as I...
6
by: maxwell | last post by:
mysql Ver 3.23.54 Having read, as best I could, the docs at http://www.mysql.com/documentation ..., on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter: mysql> GRANT ALL...
2
by: Chris M. Gamble | last post by:
I am working in a group that will be modifying tables on a regular basis. We are using postgresql 7.3.4. Is there any way to allow the other users to modify tables I have created using either user...
1
by: zeus | last post by:
Hi there, I am using Postgresql 7.3 and I want to grant select rights to a user on all tables in a schema, including those that may be created in the future but whose names are not yet known. I...
2
by: Ray Muforosky | last post by:
Hello everyone. I created a new user with the grant command and yet, I can't login into the database I must mention that the user was created but all the privileges are set to 'N'. This is...
0
by: Luis Correia | last post by:
hello.. with oracle 7.3.4.4 and with remote_login_passwordfile=NONE, can a user be granted the SYSDBA system privilege? Or does granting the SYSDBA system privilege imply that a password file...
1
by: melissa24 | last post by:
I have installed IBM DB2 UDB V 7.2. The default user id created was db2admin. But when I try to restore database from another db serv, I get an error saying SYSADM authority is required to perform...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
2
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
0
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.