Login

Remember

Register

Q&A
Unanswered
Tags
Categories
Ask a Question

Home
MySQL
Which privilege is enabled to create of alter a stored function?

Which privilege is enabled to create of alter a stored function?

← Prev Question Next Question →

+1 vote

114 views

asked Jul 21, 2021 in MySQL by Genesis (122k points)

Which privilege is enabled to create of alter a stored function?

(a) SUPER

(b) PRIOR

(c) TOP

(d) SUPERIOR

I got this question in a job interview.

My question is based upon Security for Stored Programs and Views topic in division Stored Programs of MySQL

mysql
stored programs
security for stored programs and views

Share it on

Facebook Twitter LinkedIn

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

+2 votes

answered Jul 23, 2021 by Grace (692k points)
selected Jul 24, 2021 by Genesis

Best answer

The correct answer is (a) SUPER

Explanation: In order to create or alter a stored function, the SUPER privilege should be given in addition to the CREATE ROUTINE privilege that is normally required. Depending on the DEFINER value in the function definition SUPER might be required.

Please log in or register to add a comment.

Related questions

+1 vote

1 answer

The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
security for stored programs and views

+1 vote

1 answer

A stored procedure is invoked using the statement __________

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
security for stored programs and views

+1 vote

1 answer

When a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access, the security context is __________

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
security for stored programs and views

+1 vote

1 answer

When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
security for stored programs and views

+1 vote

1 answer

The creation of a stored program is similar to the definition of a _______________

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
security for stored programs and views

+1 vote

1 answer

What produces result sets?

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
security for stored programs and views

+1 vote

1 answer

Triggers and events are invoked automatically by the server.

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
security for stored programs and views

+1 vote

1 answer

Which privilege must be given to the database to create a stored function or procedure?

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
stored functions and procedures

+1 vote

1 answer

To create or drop events for a database, which privilege should be granted?

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
events

+1 vote

1 answer

The TRIGGER privilege is used for the table to be able to create and drop triggers for it.

asked Jul 21, 2021 in MySQL by Genesis (122k points)

mysql
stored programs
triggers

Share it on

Facebook Twitter LinkedIn

Welcome to TalkJarvis QnA, a question-answer community website for the people by the people. On TalkJarvis QnA you can ask your doubts, curiosity, questions and whatever going in your mind either related to studies or others. Experts and people from different fields will answer.

Most popular tags

biology – class 12 biology – class 11 construction & building materials chemistry – class 12 electronic devices & circuits network theory data structures & algorithms ii cell biology ic engine insurance finance money computational fluid dynamics engineering physics i discrete mathematics chemistry – class 11 aerodynamics casting-forming-welding i engineering mathematics operating system casting-forming-welding ii engineering drawing mysql engineering geology digital circuits wireless mobile energy management electrical measurements digital communications cyber security analytical instrumentation embedded systems electric drives cytogenetics advanced machining computer fundamentals life sciences basic civil engineering iot design of electrical machines physics – class 12 applied chemistry dairy engineering basic chemical engineering cloud computing microprocessor bioinformatics aircraft design aircraft maintenance software engineering drug biotechnology digital signal processing biochemistry data structures & algorithms i automotive engine design avionics engineering material & metallurgy energy engineering cognitive radio unix electrical machines biomedical instrumentation object oriented programming electromagnetic theory power electronics analog communications bioprocess engineering civil engineering drawing engineering metrology physics – class 11 mathematics – class 12 engineering chemistry i basic electrical engineering unit processes mongodb signals and systems cryptograph & network security hadoop mathematics – class 11 engineering physics ii html control systems engineering mechanics antennas analog circuits computer network java sql server javascript concrete technology chemical process calculation artificial intelligence design of steel structures c++ database management computer architecture engineering chemistry ii corrosion engineering chemical technology dc machines

Send feedback
About Us
Copyright
Privacy Policy
Terms of Use
Contact Us

Powered by TalkJarvis

...