First, your terminology is likely to impede being able to get any help because people are going to have a hard time understanding what you're saying. I'll try to help you out.
Tiles are just a a small singular square graphic of a particular dimension. They don't really do anything by themselves. However, ultimately everything you see on the screen is built from tiles. Put them together and they can make a background image or static objects. For action objects, you're going to need something more.
Let's move up the scale. Next, there are sprites. Sprites on the SNES are basically defined graphical objects with some available attributes to allow them to do some basic things on the screen. Attributes include things like coordinates, palette indexes, how many tiles make it up, and flipping. Sprites are typically the player, enemies, power-ups, etc. Action items. Sprites can only do what the attributes defined by the system allow, which is minimal. Let's move up again.
Now we move into the game code space. This is where you are no longer limited in what you can do. The game will have all sorts of code defining the details of game objects including your player and enemies that are represented by sprite objects on screen. So, it is there in the game's code that you will find lines of code that manipulate the sprites into on screen actions such as animation and also off-screen actions such as damage.
I cannot even begin to explain game code to you. To start, you will need to learn about assembly language, debuggers, and how to interact with the hardware via registers to set the tiles and sprite objects we've talked about. We have various documents on this site on SNES hardware and available debuggers. We have some assembly guides, but you can Google for even more board information on the subject.
What you want to do is not a trivial task and make take you weeks or months to learn necessary material if you're starting with no knowledge. Know that you are more likely to get answers to your questions if they are more specific than the general question you asked here.