Question

what database objects can be secured by restricting access with sql statements

Answer 1

Answer:

Tables, Indexes, Views, and Stored procedures.

Explanation:

SQL(Structured Query Language) is a computer language for storing, manipulating and retrieving facts saved in a relational database. It is the usual language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their fashionable database language.

Securing database items can assist shield towards facts robbery and different breaches. We can shield a desk through growing a completely unique call for it and imposing a password coverage for customers who get right of entry to the desk.  We also can create an index to hurry up searches withinside the database. We also can steady a view through limiting get right of entry to to its columns.

#SPJ2

Answer 2

Tables, indexes, views, and stored procedures are all database objects that can be protected with SQL statements.

SQL ( Structured Query Language)

• SQL is a programming language that is used to access and manipulate databases.
• SQL is a database management system that allows you to access and manipulate data.
• In 1986, the American National Standards Institute (ANSI) approved SQL as a standard, and in 1987, the International Organization for Standardization (ISO) approved it.

Functions of SQL

• SQL is capable of running queries against a database.
• SQL can be used to get information from a database.
• SQL can be used to create new records in a database.
• SQL can be used to update data in a database.
• SQL has the ability to delete records from a database.
• SQL has the ability to build new databases.
• SQL has the ability to create new tables in a database.
• In a database, SQL can create stored procedures.
• In a database, SQL can be used to create views.
• Tables, procedures, and views can all have permissions configured in SQL.

SQL Database security

Data theft and other breaches can be mitigated by securing Tables, indexes, views, and stored procedures.

For example,

1. You can secure a table by giving it a unique name and requiring users who use it to follow a password policy.
2. You may also establish an index to help speed up database searches.
3. You can also protect a view by limiting access to its columns.

Know more about SQL database here,

https://brainly.in/question/36516659?msp_poc_exp=4

#SPJ2